Changing orientation of spreadsheet - HELP!

I have been given a spreadsheet that has all values going from left to right (horizontally). I want to convert the text to read from top to bottom. Instead of copying each cell and pasting when I want, is there a way to easily convert the entire spreadsheet?
Thanks,
mari

Copy / Paste Special / Transpose