columns to rows

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

a7n9

Well-known Member
Joined
Sep 15, 2004
Messages
696
Do you mean something like Paste Special>Transpose? or something different?
 

thetank

Board Regular
Joined
Mar 17, 2005
Messages
142
That didn't work. I have a column of about 28 names and I would like to convert them into a row.

Thanks for your help.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
thetank said:
That didn't work. I have a column of about 28 names and I would like to convert them into a row.

Thanks for your help.

Edit|Copy the names range.
Select a destination cell.
Edit|Paste Special >Transpose
 

Watch MrExcel Video

Forum statistics

Threads
1,118,763
Messages
5,574,096
Members
412,567
Latest member
mm1
Top