ExcelBanter - Excel: is it possible to move column contents into a line

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel: is it possible to move column contents into a line (https://www.excelbanter.com/excel-discussion-misc-queries/30800-excel-possible-move-column-contents-into-line.html)

Ginger

Excel: is it possible to move column contents into a line

Excel 2000: is it possible to move column contents into a line?
ie move column contents A B C to become Column headings A B C.
How is it done.
I used to be able to 'transpose' on earlier versions of Excel but am unable
to find it here.
Thanks

Dave Peterson

Copy your cells
select the new location
edit|paste special|transpose (at the bottom)

Remember that you can only use 256 columns.

Ginger wrote:

Excel 2000: is it possible to move column contents into a line?
ie move column contents A B C to become Column headings A B C.
How is it done.
I used to be able to 'transpose' on earlier versions of Excel but am unable
to find it here.
Thanks

--

Dave Peterson

ginger

Excellent! Many thanks
Ginger

"Dave Peterson" wrote:

Copy your cells
select the new location
edit|paste special|transpose (at the bottom)

Remember that you can only use 256 columns.

Ginger wrote:

Excel 2000: is it possible to move column contents into a line?
ie move column contents A B C to become Column headings A B C.
How is it done.
I used to be able to 'transpose' on earlier versions of Excel but am unable
to find it here.
Thanks

--

Dave Peterson

All times are GMT +1. The time now is 01:33 AM.