title: Transpose a pair of columns into a single row
body: <p>I have a two column, n row table in this format:</p>
  
  <blockquote>
    <p>1 | Apple<br>
    2 | Orange<br>
    3 | Fruit<br>
    4 | Car</p>
  </blockquote>
  
  <p>I need to reformat all of the data into one row like so:</p>
  
  <blockquote>
    <p>1 | Apple | 2 | Orange | 3 | Fruit | 4  |Car  </p>
  </blockquote>
  
  <p>I am aware of Paste Special using Transpose, but that still gives me a row for each column.  </p>
  
  <p>What would be the best approach to this?</p>