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 ?
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 ?
Copy
Paste Special, Transpose
"Sharon" <[email protected]> wrote in message
news:[email protected]...
> 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 ?
Steve - Thanks a million - you've saved me a lot of time.
"Steve" wrote:
> Copy
> Paste Special, Transpose
>
>
> "Sharon" <[email protected]> wrote in message
> news:[email protected]...
> > 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 ?
>
>
>
Sharon
Copy>Paste Special>Transpose.
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 <[email protected]>
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 ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks