convert row to column

I

Ivor Williams

I have information in a row on a spreadsheet. Is there a way to copy/cut and
paste that information into a column instead?

TIA
Ivor
 
C

Christopher

Have you tried the Transpose yet? You copy the row, select the column you want to put the data in, paste special and check the transpose box
 
J

JMay

Highlight and Copy the Row;
then go to the column cell you wish the data to goto and click/select it,
then
do an Edit Paste-Special (check) Transpose<<Consider if you want to further
paste the de-formularized Value or not, also before ending>>
HTH
 
Top