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:
ID,NAME,DOB,POSTCODE
1,ryan,11/11/11,xxx xxx
Any help/advice would be much appreciated
Thanks
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:
ID,NAME,DOB,POSTCODE
1,ryan,11/11/11,xxx xxx
Any help/advice would be much appreciated
Thanks