title: teradata sql pivot multiple occurrences into additional columns
body: <p>I have something like this:</p>
  
  <pre><code>ID      Result
  1       value1
  2       value1
  2       value2
  3       value1
  4       value1
  4       value2
  4       value3
  </code></pre>
  
  <p>And I'd like to return something like this:</p>
  
  <pre><code>ID      Result1      Result2      Result3
  1       value1
  2       value1       value2
  3       value1
  4       value1       value2       value3
  </code></pre>
  
  <p>I've searched on pivots and concats and breaks and I just can't find a simple, sensible solution.</p>
  
  <p>TIA</p>