Hello,

Can someone please tell me how I can swap Row and Coloumn
headers in Excel keeping the corresponding data
consistent.

Thanks!
-Masri

Copy your data to a new worksheet (as a test) using Paste Special --
Transpose.

Rgds,
Andy

You can't, but you can swap the data round keeping the row and column headers consistent. Copy
the data, select a new cell outside your existing data range, then do Edit / Paste Special /
Tranpose. Now just delete the original data and move the new table to where the old data was.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
There's no 'I' in 'Team'
----------------------------------------------------------------------------



"Masri" <(E-Mail Removed)> wrote in message news:616c01c340da$24aafe20$(E-Mail Removed)...
> Hello,
>
> Can someone please tell me how I can swap Row and Coloumn
> headers in Excel keeping the corresponding data
> consistent.
>
> Thanks!
> -Masri

Masri

Try out copy>paste special>Transpose. May be what you need. Limitation is
you cannot have more than 255 rows(less if you have more than one column).

i.e. 256 minus number of columns

Gord Dibben Excel MVP - XL97 SR2 & XL2002

Gord Dibben Excel MVP - XL97 SR2 & XL2002

On Wed, 2 Jul 2003 13:40:15 -0700, "Masri" <(E-Mail Removed)> wrote:

>Hello,
>
>Can someone please tell me how I can swap Row and Coloumn
>headers in Excel keeping the corresponding data
>consistent.
>
>Thanks!
>-Masri

Thanks a lot! It worked!
>-----Original Message-----
>You can't, but you can swap the data round keeping the
row and column headers consistent. Copy
>the data, select a new cell outside your existing data
range, then do Edit / Paste Special /
>Tranpose. Now just delete the original data and move
the new table to where the old data was.
>
>--
>Regards
> Ken....................... Microsoft MVP -
Excel
> Sys Spec - Win XP Pro / XL2K & XLXP
>
>---------------------------------------------------------
-------------------
> There's no 'I' in 'Team'
>---------------------------------------------------------
-------------------
>
>
>
>"Masri" <(E-Mail Removed)> wrote in message
news:616c01c340da$24aafe20$(E-Mail Removed)...
>> Hello,
>>
>> Can someone please tell me how I can swap Row and
Coloumn
>> headers in Excel keeping the corresponding data
>> consistent.
>>
>> Thanks!
>> -Masri
>
>
>.
>