From Row to Column?

C

confused man

Hello all, I have a large spreadsheet of data, unfortunately when I set it
up originally I put the data into rows (I.E. left to right) I'm trying to
correct that now, Is there any way I can highlight a row of data and move it
into a colum, in the same order it is in the rows?

Thank you,
Confused Man
 
B

Bigwheel

Yep, select all the cells in your row, and copy then select the first cell
in your destination column and select "Paste Special" then transpose in the
Paste Special dialog and ... job done!!
 
D

Dave Peterson

Select your range and then
Edit|Copy
then select where it should be pasted and
Edit|paste special|and check the transpose box

(You can't overlap the From and To ranges while you're doing this)
 
Top