title: Convert rows into columns for each distinct id
body: <p>I want to convert this</p>
  <pre><code>tran_id tran_text
  1       A
  2       B
  3       C
  1       first
  2       second
  3       third
  1       alpha
  2       beta
  3       gamma
  </code></pre>
  <p>into this</p>
  <pre><code>tran_id tran_text1 tran_text2 tran_text3
  1       A          first      alpha
  2       B          second     beta
  3       C          third      gamma
  </code></pre>
  <p>My ultimate goal is to concat the three values for each tran_id (there are exactly three for each) into a new value, select it, and use it to update another transaction table with the concatenated value.</p>