"Pivot" a table in Excel

Question

I've got a large set of data in Excel 2007, but the rows should have been columns, and vice-versa. Is there a simply way to "pivot" this spreadsheet, rearranging all cells so that the rows become the columns?

Answer 1

Yes, use Paste Special and choose Transpose.

Answer 2

You can do pivots in most if not all versions of Excel. Pivot Table Tutorial Excel 2003 and Excel 2007 tutorial

Once you learn Pivot Tables, you'll wonder how you survived Excel without them