title: Appending every second row to the first row in a dataframe
body: <p>I have a dataframe (created from an excel sheet) where every second row needs to be appended to the end of the first row.</p>
  
  <p>For example - </p>
  
  <pre><code>Data in Row 1 = A B C D E ... AK (i.e. the number of columns in the first row is 37)
  
  Data in Row 2 = a b c d e ... l (i.e. the number of columns in the second row is 12)
  
  Data in Row 3 = A B C D E ... AK
  
  Data in Row 4 = a b c d e ... l
  </code></pre>
  
  <p>etc.</p>
  
  <p>The number of rows is variable (depending on the content of the original spreadsheet) but the number of columns is always the same.</p>
  
  <p><strong>I need row n+1 to be appended to the end of row n resulting in row n having 49 columns of data.</strong>  </p>
  
  <p>The new rows would look like this -</p>
  
  <pre><code>Row 1 = A B C D E ... AK a b c d e ... l
  
  Row 2 = A B C D E ... AK a b c d e ... l
  </code></pre>
  
  <p>etc.</p>
  
  <p>The final array will have half the number of rows we started out with.</p>
  
  <p>I think the solution lies in the use of 'reshape' and 'arange', but I can't figure it out.</p>
  
  <p>Thanks</p>