2

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?

Robin Rodricks
  • 110,798
  • 141
  • 398
  • 607

1 Answers1

8

Yes, use Paste Special and choose Transpose.

JP Alioto
  • 44,864
  • 6
  • 88
  • 112