Recently I have needed to invert / swap / transpose the data I had represented as columns into data represented as rows. The data as in most cases was a table stored in Microsoft Excel. Finding the answer (the first time) took a few Googles through the web (the second and third time was a lot easier).
I was expecting there to be a menu option hidden somewhere under Format or Data or some other obscure place, but it turns out that this function has been provided in the copy paste functionality of Excel.
All you need to do is copy your data (make sure you select all of it) and then use the Paste -> Transpose function to paste it over the old data or into a new sheet.
The Original data set
The Final data set