title: Rearrange data in a single column into multiple columns with Excel Power Query
body: <p>I have data that is a function of two parameters that is imported from a .yaml file. The first column contains one of the parameters, the second column contains the data grouped by the second parameter which is included at the beginning of each group. I want to transform this data into a 2-dimensional table in Excel for graphing multiple parameterized lines. </p>
  
  <p>The .yaml file looks like this.  It will always be fixed length:</p>
  
  <pre><code>A:
    a: 1
    b: 2
    c: 3
  B:
    a: 4
    b: 5
    c: 6
  </code></pre>
  
  <p>The imported data looks like this in Power Query (after importing as non-delimited text and minor manipulation in Excel Power Query):</p>
  
  <pre><code>Column1  |  Column2
  -------------------
    null   |    A
     a     |    1
     b     |    2
     c     |    3
    null   |    B
     a     |    4
     b     |    5
     c     |    6
  </code></pre>
  
  <p>I'd like to transform it to this:</p>
  
  <pre><code>Column1 | Column2 | Column3
  ---------------------------
   null   |    A    |   B
    a     |    1    |   4
    b     |    2    |   5
    c     |    3    |   6
  </code></pre>
  
  <p>I don't need a complete solution, just a yes or no for whether it can be done, and the key concepts of the solution if it can be done. I'll fill in the details for any solutions as I have time to work through them (since this is what Stack Exchange wants to see, detailed solutions).</p>