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

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!

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

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


"cfman" wrote:

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!

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

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

"cfman" wrote:

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!

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

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


"Ron Coderre" wrote in message
...
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


"cfman" wrote:

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!

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

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

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

"cfman" wrote:

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!

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

Copy the range of 10 cells.

Select a cell out of the range and EditPaste SpecialTransposeOKEsc.

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


Gord Dibben MS Excel MVP

On Mon, 9 Apr 2007 13:10:02 -0700, "cfman" wrote:

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

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

"cfman" wrote:

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!

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

Hi

Copy the data, choose a destination cellPaste Special.Transpose

--
Regards

Roger Govier


"cfman" wrote in message
...
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...

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

"cfman" wrote:

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!

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

Mon, 9 Apr 2007 12:46:28 -0700 from cfman :
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.

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