title: Excel - transpose pairs of columns
body: <p>I'm attempting to transpose - if that's the right application of the term - pairs of columns into repeating rows. In concrete terms, I need to go from this:</p>
  
  <pre><code>Thing1     6    0.29    5   0.23    7   0.19    8   0.11
  </code></pre>
  
  <p>to this:</p>
  
  <pre><code>Thing1     6    0.29
  Thing1     5    0.23
  Thing1     7    0.19
  Thing1     8    0.11
  </code></pre>
  
  <p>This operation will occur with at least 7 pairs of columns for several hundred "things." The part I can't figure out is how to group/lock the pairs to be treated as one unit. </p>
  
  <p>In some ways, I'm trying to do the opposite of what is normally done. One example is here: <a href="https://stackoverflow.com/questions/17853218/transpose-and-group-data-in-excel">Transpose and group data</a> but it doesn't quite fit, even if I attempt to look at it backwards. </p>
  
  <p>EDIT: Another example that is similar, but I need to do almost the reverse: <a href="https://stackoverflow.com/questions/11919597/how-to-transpose-one-or-more-column-pairs-to-the-matching-record-in-excel?rq=1">How to transpose one or more column pairs to the matching record in Excel?</a></p>
  
  <p>My VBA kung fu is weak, but I'm willing to try whatever your collective wisdom suggests.</p>
  
  <p>Ideas are welcome, and in any case, thank you for reading.</p>