Cheers fellas, especially for those offering to do the job for me, but it's done now.
I found that COPY, PASTE SPECIAL, TRANSPOSE was able to transfer the cells from Rows to Columns, but I had to highlight the relevant cells for each record because they all had different numbers of Rows in them, and I had over 100 records so it took a while!!