I've been given a CSV file that is organised by this format. It reads something like:
ID,1
Name,Ryan
DOB,11/11/11
Postcode,xxx xxx
I'm able to separate the values into an Excel spreadsheet but struggling to figure out how to efficiently move the cells into my desired format. E.G...