title: Excel Data Conundrum
body: <p>Hey I'm wondering if anybody with a better brain would be able to think of a solution for the below please:</p>
  
  <p>I have 900 rows of data like so:</p>
  
  <p><a href="https://i.stack.imgur.com/AvDNu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AvDNu.png" alt="enter image description here"></a></p>
  
  <p>Which I need to be like so:</p>
  
  <p><a href="https://i.stack.imgur.com/95QDu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/95QDu.png" alt="enter image description here"></a></p>
  
  <p>I would do this manually but for 900 rows and 25 columns, it's not really a feasible option.</p>
  
  <p>I appreciate this may not even be possible using standard Excel functions, but I'm so desperate that I'm open to any ideas. Thank you very much in advance for any insight that you can offer me :)</p>