title: Rearrange certain columns and rows
body: <p>I have an Excel spreadsheet formatted like this:</p>
  
  <p><img src="https://i.stack.imgur.com/mO1UM.png" alt="Before"></p>
  
  <p>What I have been trying to do is format it to look like this:</p>
  
  <p><img src="https://i.stack.imgur.com/qw0nC.png" alt="After"></p>
  
  <p>So it's kind of transposed I guess (not sure how to call it).</p>
  
  <p>I've spent the last hour and a half trying to do it in VBA with no success.</p>
  
  <p>This is just a sample of how it is formatted, in reality there's about 50,000 of these, so I need to do it using VBA or something of the sort.</p>
  
  <p>Would someone be able to help me out with how to do this?</p>