change column to row display

  • Thread starter Thread starter Russ
  • Start date Start date
R

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
 
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 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)

Russ said:
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
Click to expand...
Click to expand...
 
Back
Top