change column to row display

[Russ]

I have some data that I paste into a spreadsheet that results in a
column of data. Is there a way to paste this column data into a row,
or can I convert existing column data in a spreadsheet into a row?

Russ

 

[Ron Coderre]

Assuming you have less than 256 cells of data
(unless you're using XL2007)

Try this:

Select from the SECOND item down through the bottom of the list.
From the Excel Main Menu:
<edit><copy>

Select the single cell to the right of the FIRST item in the list
<edit><paste special>...Check: Transpose....Click [OK]

Clear the cells under the first cell.

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Tyro]

Yes. Copy/Paste Special/Transpose

Tyro

 

[Russ]

I think that will do it. Or maybe I can modify my spreadsheet to
accept the vertical data as well or make a macro to automate some of
this work. Thanks alot.

Russ

Assuming you have less than 256 cells of data
(unless you're using XL2007)

Try this:

Select from the SECOND item down through the bottom of the list.
From the Excel Main Menu:
<edit><copy>

Select the single cell to the right of the FIRST item in the list
<edit><paste special>...Check: Transpose....Click [OK]

Clear the cells under the first cell.

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

I have some data that I paste into a spreadsheet that results in a
column of data. Is there a way to paste this column data into a row,
or can I convert existing column data in a spreadsheet into a row?

Russ