title: macro to re-arrange data
body: <p>I have been trying to write a macro to re-arrange the Cells in the rows and columns of Stock tables for the output I desire. Luckily the Stock Tables are generally the same each and every time (Different names and values), and the desired outcome is the same format.. </p>
  
  <p>Here is some example Data. </p>
  
  <pre><code>      A                        
  </code></pre>
  
  <p>1 Name<br>
  2 description<br>
  3 description<br>
  4 description<br>
  5 description<br>
  6 ID#: 56284<br>
  7 Quantity in stock: 34<br>
  8 Zoom In and Configure </p>
  
  <pre><code>      B
  </code></pre>
  
  <p>1 Name<br>
  2 description<br>
  3 description<br>
  4 description<br>
  5 description<br>
  6 ID#: 56284<br>
  7 Quantity in stock: 50<br>
  8 Zoom In and Configure </p>
  
  <p>And I would like the Output to go into something like this(If possible to sheet2 starting on Cell B2):</p>
  
  <pre><code>B    C    E
  </code></pre>
  
  <p>B Being Row 1
  C being Row 2 3 4 and 5 Combined
  E being JUST Row 7 Stock Value I.E 50</p>
  
  <p>On a single spreadsheet there would be 4 columns, and 8 rows I would have to re-arrange.. Making 32 total. </p>
  
  <p>It would be great to automated this, so any help would be greatly appreciated. </p>