title: Take two rows of data at once and put the data into two columns?
body: <p>What SQL code will transform the input table to the output table in this example? (Assume some ordering, odd rows go to column2 and even rows go to column3 with consecutive odd-even pairs on the same output row.)</p>
  
  <pre><code>input table:
  column1
    A
    B
    C
    D
    E
    F
  
  output table:
  column2    column3
    A          B
    C          D
    E          F
  </code></pre>
  
  <p><strong>Update:</strong>
  Assuming some ordering, odd rows go to column2 and even rows go to column3 with consecutive odd-even pairs on the same output row</p>