| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
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! |
|
#7
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
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! |
|
#8
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i rotate data - see below | Excel Discussion (Misc queries) | |||
| importing from Access & need to rotate data--can't transpose--HELP | Excel Discussion (Misc queries) | |||
| Rotate data by date | Excel Discussion (Misc queries) | |||
| Rotate excel data axis, not in chart format | Excel Discussion (Misc queries) | |||
| How do I rotate data in a spreadsheet so that rows become columns? | Excel Discussion (Misc queries) | |||
Hybrid Mode
