PC Review


Reply
Thread Tools Rate Thread

How can I invert an Excel List, means colums become rows and vv.?

 
 
=?Utf-8?B?dG9tY2F0?=
Guest
Posts: n/a
 
      24th Aug 2007

 
Reply With Quote
 
 
 
 
Niek Otten
Guest
Posts: n/a
 
      24th Aug 2007
Copy and Paste Special, check Transpose

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"tomcat" <(E-Mail Removed)> wrote in message news:40585F53-D41A-4235-B7A1-(E-Mail Removed)...
|


 
Reply With Quote
 
David Biddulph
Guest
Posts: n/a
 
      24th Aug 2007
Firstly, please ask your question in the body of the message, not just in
the subject line. Blank messages will often be rejected or ignored.

The function you want is transpose, so you either want the TRANSPOSE
function, or you want to copy the data and use Edit/ Paste Special/
Transpose to copy in a transposed array.
--
David Biddulph

"tomcat" <(E-Mail Removed)> wrote in message
news:40585F53-D41A-4235-B7A1-(E-Mail Removed)...
>



 
Reply With Quote
 
=?Utf-8?B?Y2hhbGxhIHByYWJodQ==?=
Guest
Posts: n/a
 
      28th Aug 2007
Hi,

If it is a List. then convert the List to Range.

Procedure

1. Do one of the following;

On the Data menu, point to List and then click Convert to Range.
-or-
Right-click and select Convert to Range
Once you convert to range the arrow will not appear to the right of list
column header.
2. Select the range
3. On the Edit menu, click Copy.
4. Clik on differen cell location.
5. On the Edit menu, click Paste Special. The Paste Speial dialog is
displayed.
6. Select the Transpose check box.
7. Click Ok to return to the Worksheet. Now the Column text is converted to
a row.

Challa Prabhu

>
> "tomcat" <(E-Mail Removed)> wrote in message news:40585F53-D41A-4235-B7A1-(E-Mail Removed)...
> |
>
>
>

 
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
excel colums and rows vic Microsoft Excel Setup 1 17th Jan 2008 02:03 AM
How do I invert an Excel table (collumns become rows)? songstarter Microsoft Excel Worksheet Functions 1 2nd Jan 2008 07:01 PM
how can i change my sprdsht to list info from colums into rows =?Utf-8?B?a2F0ZQ==?= Microsoft Excel Worksheet Functions 0 18th Apr 2006 03:56 PM
how do I invert the rows and colums in excel? =?Utf-8?B?QWxkb2ZhYnJpemk=?= Microsoft Excel Misc 2 19th Oct 2005 07:45 PM
i want my excel colums to be rows =?Utf-8?B?cGV0ZXI=?= Microsoft Excel Worksheet Functions 1 29th Mar 2005 10:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:51 PM.