Can I invert a table so row headings are now column headings etc

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" <Sharon@discussions.microsoft.com> wrote in message
news:5C39223B-D1CD-4626-A8FC-E17FD023EA3F@microsoft.com...
> 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" <Sharon@discussions.microsoft.com> wrote in message
> news:5C39223B-D1CD-4626-A8FC-E17FD023EA3F@microsoft.com...
> > 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 <Sharon@discussions.microsoft.com>
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 ?