title: Importing CSV that has an extra row represented as new columns
body: <p>As the title says, I'm attempting to import about 30 CSV files and combine into one. Each file has 15 of the 'correct' columns, with an additional 15 columns of only one row's worth of data. So, in total, each file appears to have 30 columns, but in reality there should only be 15 columns, and the second set of columns should just be appended to the bottom of my data as an extra row. For a smaller example, it looks something like this:</p>
  
  <pre><code>Col1 Col2 Col3 Col4 Col5 5.87 6.12 5.50 4.98 2.87
  2.50 3.50 5.66 5.23 2.11
  1.12 9.99 1.15 5.44 3.12
  </code></pre>
  
  <p>I'm looking to take those 5 'extra' columns (which are really just one extra row) and move them to the bottom of my data, as another row, instead of appearing as 5 more columns.</p>