columns to rows

[hostelowner]

hello,

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

 

[Legacy 51064]

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]

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"

 

[hostelowner]

thanks

awsome....
thank you both