title: Split/separate column into multiple columns
body: <p>I'm completely stuck and I cannot find any answers for this problem even though problem seems to be quite simple. Can I separate that 'description' column without making a new table?</p>
  
  <p>For now I just wrote this simplest code.</p>
  
  <pre><code>select item_id, description
  from data
  where item_id = '123'
  </code></pre>
  
  <p>With that code it looks like this:</p>
  
  <pre><code>item_id description
  123     A
  123     B
  123     C
  </code></pre>
  
  <p>But I'd like to make it look like this:</p>
  
  <pre><code>item_id desc_1 desc_1 desc_2
  123     A      B      C
  </code></pre>