columns to rows

hostelowner

Board Regular
Joined
Apr 19, 2005
Messages
105
hello,

how can i move data listed on 1 row 10 columns into 1 column 10 rows..
thanks
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
L

Legacy 51064

Guest
I would either use the transpose formula or edit-paste special - transpose function:

If your data is in column A3:J13

Highlight A4:A14 and type in this formula and press ctrl+shift+enter
=TRANSPOSE(A4:A14)
 

Mark O'Brien

MrExcel MVP
Joined
Feb 15, 2002
Messages
3,530
1. Highlight the data
2. Hit CTRL+c to copy data
3. Select the cell that the first piece of data is to be located in
4. From the toolbar choose "EDIT|Paste Special"
5. Select the "Transpose" option
6. Hit "OK"
 

Watch MrExcel Video

Forum statistics

Threads
1,119,269
Messages
5,577,108
Members
412,768
Latest member
klig
Top