Reorganizing Cells Within Excel

[Jeavo]

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

 

[Jeavo]

I believe I have solved my issue. You can copy the data and paste it into a new area under the "Special Paste -> Transpose data" option.