How to move numerous sets of data from columns to rows within a table?

Hi there

Aside from the "Paste Special's" TRANSPOSE checKbox, im not sure what other functions there are on excel that can solve this small issue of mine.

Ive attached the file with the original issue and the ideal scenario.

Any assistance would be greatly appreciated

Cheers
Rob