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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Sal Iaccarino" <siaccarina@swfla.rr.com> wrote in message
news:mkYLf.40977$g47.16942@tornado.tampabay.rr.com...
>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
>
>

[bzimm88]

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.

"Sal Iaccarino" wrote:

> 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
>
>
>

[michael.amon1@gmail.com]

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

[badgercat]

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


"michael.amon1@gmail.com" wrote:

> 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
>
>