Excel: Is there an easy way to....

[dcasper70]

Change the rows to columns and columns to rows, all at once?

I have groups in the rows, categories in the columns and need to do a flip flop of the data.

[ddollevoet]

Copy, Paste special, transpose.

[dcasper70]

niiiiiiiiiiiiiiice

I owe you 3 hours