Coverting data in a one column into a single row

[Vishnu]

I am pretty sure this is easy question.

I would like to know if there is a quick way to convert data that is in
Column A from cells A1: A26 into Row 1 from cells A1: Z1


That is to convert data in a column into a row.

Thanks in advance

[simonsmith]

Try...

copy, paste special (then tick) transpose

[Vishnu]

i found it..i searched in help. it told me to copy the cells first and then
select the destination cell and do a paste special and check transpose

"Vishnu" wrote:

> I am pretty sure this is easy question.
>
> I would like to know if there is a quick way to convert data that is in
> Column A from cells A1: A26 into Row 1 from cells A1: Z1
>
>
> That is to convert data in a column into a row.
>
> Thanks in advance