Highlight your data and copy it into the clipboard. Move to an open
spot in the spreadsheet and click Edit Paste Special, then select the
Transpose box and click OK. It takes a little getting used to, but
should do what you need.