Coverting data in a one column into a single row

V

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
 
V

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
 
Top