Transpose Data from the Excel Plugin

You can do this by downloading the Plugin from here (if you don't already have this installed)

You can either view a saved selection from the databank directly into Excel:

or you can download into Excel:

Once you have your selection ready, you can now transpose the data by highlighting the data in the spreadsheet and clicking on Transpose Data