Convert row data into column data

[lunker55]

I have a row of data that I want to arrange in a column.

I have a about 25 cells in 1 row with data.
I want 25 cells in 1 column with the data.
Is there an easy way to convert the row into a column?
I thought I saw how on the newsgroup, but can't find it now.

Thanks,
Joe

 

[DDM]

Lunker, select the cells, then Edit > Copy. Select a destination cell, then
Edit > Paste Special > Transpose > OK.

 

[ianripping]

Hi Joe, its really hard to explain... heres an example

Attachment filename: row into column.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56566

 

[ianripping]

That way it also good. Im stuck in excel 97

 

[Dave Peterson]

That should work in xl97, too.

What's in your data that stops it from working?

 

[lunker55]

Thanks Ian and DDM. Works great.

Joe

That should work in xl97, too.

What's in your data that stops it from working?