Transpose multiple sets of data at once?

[ccastell88]

Hey guys,

I was wondering if there is a easier way to transpose multiple sets of data at once.

Its a bit difficult to explain, so i have attached a excel document with two sheets one input (the data that i want to transpose) and output (what i want it to look like).

Any suggestions on how to do this would be very much appreciated!

Thankyou,
Chris

[FDibbins]

Have you tried the TRANSPOSE function?
Find it under Home TAB/Paste drop-down/Transpose

You highlight the entire range (or you can do a row at a time, up to you), copy/paste Transpose