PC Review


Reply
Thread Tools Rate Thread

swap column and row headers

 
 
Masri
Guest
Posts: n/a
 
      2nd Jul 2003
Hello,

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

Thanks!
-Masri
 
Reply With Quote
 
 
 
 
Andy Brown
Guest
Posts: n/a
 
      2nd Jul 2003
Copy your data to a new worksheet (as a test) using Paste Special --
Transpose.

Rgds,
Andy


 
Reply With Quote
 
 
 
 
Ken Wright
Guest
Posts: n/a
 
      2nd Jul 2003
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



 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      2nd Jul 2003
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


 
Reply With Quote
 
Masri Bakhil
Guest
Posts: n/a
 
      7th Jul 2003
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

>
>
>.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup using column headers and row headers Memphus01 Microsoft Excel Misc 1 13th Apr 2009 04:57 PM
How to set Column headers as row headers in Data grid control =?Utf-8?B?VlIgUmF2aW51dGhhbGE=?= Microsoft Dot NET Framework Forms 1 3rd May 2005 12:25 AM
How do I make column headers into row headers and make vertical d. =?Utf-8?B?VGVhbSBJSVAgRGF2ZQ==?= Microsoft Access External Data 0 20th Dec 2004 03:47 PM
How do I make column headers into row headers and make vertical d. =?Utf-8?B?VGVhbSBJSVAgRGF2ZQ==?= Microsoft Access External Data 0 20th Dec 2004 03:39 PM
Row headers instead of Column headers Robert Neville Microsoft Access Reports 4 27th Sep 2003 08:48 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:38 AM.