Is there a way to rotate a column of data into a row of data?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cfman - 09 Apr 2007 20:46 GMT

Hi all,

Is there a way to rotate a column of data into a row of data, in Excell
2003?

Let's say B8 - B1000, there are so many of them... I want to rotate it into
a row form...

Thanks a lot!

Reply to this Message

Ron Coderre - 09 Apr 2007 20:54 GMT

You'll need to explain the rules a little better....

You want to convert 992 vertical cells
into one row
....but Excel 2003 only has 256 columns.

***********
Regards,
Ron

XL2002, WinXP

> Hi all,
>
[quoted text clipped - 5 lines]
>
> Thanks a lot!

Reply to this Message

cfman - 09 Apr 2007 21:09 GMT

sorry I mean one column only,

I want one column (selected) to be rotated into one row...

i.e.

Want:

A
B
C
D
...

be rotated into:

A B C D ...

> You'll need to explain the rules a little better....
>
[quoted text clipped - 18 lines]
>>
>> Thanks a lot!

Reply to this Message

bj - 09 Apr 2007 20:56 GMT

you can only have 256 entries in one row.
you would have to split it into several rows

> Hi all,
>
[quoted text clipped - 5 lines]
>
> Thanks a lot!

Reply to this Message

cfman - 09 Apr 2007 21:10 GMT

Okay, let's say I have 10 cell in one column, selected, how to rotate into
10 cell in one row?

The numbers are arbitrary... I just want to know the method...

Otherwise I have to retype everything, that's troublesome...

> you can only have 256 entries in one row.
> you would have to split it into several rows
[quoted text clipped - 9 lines]
>>
>> Thanks a lot!

Reply to this Message

Gord Dibben - 09 Apr 2007 21:15 GMT

Copy the range of 10 cells.

Select a cell out of the range and Edit>Paste Special>Transpose>OK>Esc.

As others have pointed out, the limit is 256 cells.

Gord Dibben MS Excel MVP

>Okay, let's say I have 10 cell in one column, selected, how to rotate into
>10 cell in one row?
[quoted text clipped - 16 lines]
>>>
>>> Thanks a lot!

Reply to this Message

Roger Govier - 09 Apr 2007 21:17 GMT

Hi

Copy the data, choose a destination cell>Paste Special.Transpose

Signature

Regards

Roger Govier

> Okay, let's say I have 10 cell in one column, selected, how to rotate
> into 10 cell in one row?
[quoted text clipped - 17 lines]
>>>
>>> Thanks a lot!

Reply to this Message

Stan Brown - 10 Apr 2007 02:38 GMT

Mon, 9 Apr 2007 12:46:28 -0700 from cfman <comtech.usa@gmail.com>:

> Is there a way to rotate a column of data into a row of data, in Excell
> 2003?

I don't know that program, but you can do it in Excel 2003. Check the
help for TRANSPOSE.

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Reply to this Message