Sharon
CopyPaste SpecialTranspose.
NOTE: you are limited to 256 columns so if you have more rows than that you
are out of luck.
Also, you can't paste onto an area of the original data.
I like to paste onto a new worksheet so no chance of overlap.
Gord Dibben Excel MVP
On Thu, 10 Feb 2005 01:23:03 -0800, Sharon
wrote:
Does anybody know of a quick way in Excel to invert a table fully so that all
data is flipped - row headings become column headings and vice versa ?
|