title: Transpose data in Apache Pig Latin
body: <p>I need to "transpose" data that looks like this:</p>
  
  <pre><code>id      City   
  111     Chicago  
  111     New York  
  111     LA  
  222     Paris  
  222     London
  222     Tokyo
  </code></pre>
  
  <p>to:</p>
  
  <pre><code>111    Chicago    New York    LA
  222    Paris      London      Tokyo
  </code></pre>
  
  <p>Every id would have three entries each, so the resulting relation would have 4 fields. I'm trying to avoid using a UDF. Any ideas? </p>