Merging Cells and data

Hi people,

Hoping someone can help me out here. Essentially, I have a spreadsheet exported from software which allows me to look at the peer review scores recorded for academic applications - the format of the data exported is across the same column headings, with each score (of three separate scores) separated into a new row.

I am am looking for a way to more speedily do what I have already done manually for a couple of the applications- migrate the scores in the 'Recorded Score' column to respective Score 1/Score 2 / Score 3 columns. The real spreadsheet is of considerable length and it will take me a long time to do this manually.


J