Column to a row

[Sal Iaccarino]

I have a column of numbers. How do I transfer this column to a row? There
must be a function that will allow it.

Thanks,
Sal and Eileen

 

[Don Guillett]

Have a look in the help index for TRANSPOSE

 

[Guest]

I've done it with copy & paste, high light the colume of cells you want then
copy, know high light row of cells, paste them. Work for me just fine.

 

[michael.amon1]

I had this problem awhile ago, and ya, it is very simple once you're
told,
All you have to do, is select the numbers that you want to move from a
column to row, then select Edit -> Paste Special, then click the
Transpose box. This will paste your data to the opposite of what you
are selecting (column to row, or row to column).

Good luck!
Mike

 

[Guest]

Thank you very much.
It was a much needed format.