Columns to Rows?

xcellnoob

Board Regular
Joined
Apr 6, 2005
Messages
188
I did a search and couldn't find anything related, so:
Is there a way to Take a column of data and paste it so that it's a row?
So basically, column A I want to be in Row 1. Horizontal versus vertical.
Help?
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

chearn

New Member
Joined
Jan 24, 2005
Messages
14
you should be able to copy your column info then "paste special" and click on transpose, that will put your column info into a row
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
Also consider the TRANSPOSE function if you want it to be linked instead of copied/pasted values.

Note: to transpose a 2x3 rectangle, select a 3x2 range, enter =TRANSPOSE(2x3 range's addresses) and press CTRL+SHIFT+ENTER. You have to select the range first, and you have to enter with CSE.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,052
Messages
5,545,734
Members
410,702
Latest member
clizama18
Top