title: Excel Split Single Column Into Multiple Columns Based on Header Rows
body: <p>I have an excel file that contains data exported from LTSpice simulations. There are 280 different runs however the data is exported as two columns (time and voltage) with a run cell at the start of a new run. The number of data points in each run varies. Looks something like this:</p>
  
  <pre><code>Run 1/280
  Time1        Voltage1
  Time2        Voltage2
  Run 2/280
  Time1        Voltage1
  Time2        Voltage2
  Time3        Voltage3
  Run 3/280
  </code></pre>
  
  <p>I would like to have the run cells as row and the time and voltage columns beneath them.</p>
  
  <pre><code>Run 1/280                Run 2/280                Run 3/280
  Time1        Voltage1    Time1        Voltage1
  Time2        Voltage2    Time2        Voltage2
                           Time3        Voltage3
  </code></pre>
  
  <p>I haven't found an easy way to do this yet, so any help would be appreciated.</p>
  
  <p>Thanks</p>