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

N

Niek Otten

Copy and Paste Special, check Transpose

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
 
D

David Biddulph

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top