change column to row display

's Computer Specifications

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

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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

's Computer Specifications

Yes. Copy/Paste Special/Transpose

Tyro

"Russ" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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

's Computer Specifications

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

On Wed, 20 Feb 2008 21:00:57 -0500, "Ron Coderre"
<(E-Mail Removed)> wrote:

>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" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>>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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look	MPSingley@midamerican.com	Microsoft Excel Programming	2	30th Dec 2006 06:23 PM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look	MPSingley@midamerican.com	Microsoft Excel Misc	0	27th Dec 2006 04:31 PM
Display missing Part Number if Column A does not match column B	=?Utf-8?B?RXJpayBU?=	Microsoft Excel Worksheet Functions	2	17th Apr 2006 11:23 PM
Change column name display....?		Microsoft Access Queries	2	11th May 2004 11:58 PM
Change the Column display prior to show the DataGrid	=?Utf-8?B?Q2FybA==?=	Microsoft Dot NET Framework Forms	2	2nd May 2004 04:26 PM