There is a transpose function, but it is a bit tricky to use...

Select the block of cells where you want the transposed data to be,
type in =TRANSPOSE(A1:A3) where A1:A3 is replaced by the range you want,
Press Ctrl Shift Enter (rather than just Enter).

Note that the selected area MUST be the same width as the height of the range to be transposed and similarly for the height of the selected area and width of the range.

Best to try it out on a test sheet before you try to use it on your proper data.

Once you've get the hang of it you should be able to devise a combination of
TRANSPOSE with perhaps the OFFSET function....

good luck.

Mark.