Transpose multiple sets of data at once?

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