Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Horizontal?
I have this:
2004 2003 2002 2001 2000 10,862 9,231 7,972 6,448 5,028 Is there a quick way to make it this: 2000 2001 2002 2003 2005 5028 6448 7972 9231 10862 thanks... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Horizontal?
Try this:
Select your data (including headings) DataSort Click the [Options] button Check: Sort left to right Click the [OK] button Set the field to sort Ascending Click the [OK] button That should sort you data in ascending order from left to right based on the column heading value. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "SteveC" wrote: I have this: 2004 2003 2002 2001 2000 10,862 9,231 7,972 6,448 5,028 Is there a quick way to make it this: 2000 2001 2002 2003 2005 5028 6448 7972 9231 10862 thanks... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Horizontal?
Select the range
data|sort|options|check sort left to right and finish up. SteveC wrote: I have this: 2004 2003 2002 2001 2000 10,862 9,231 7,972 6,448 5,028 Is there a quick way to make it this: 2000 2001 2002 2003 2005 5028 6448 7972 9231 10862 thanks... -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Horizontal?
You could use a formula to reverse your data if you'd like to change
locations. Original data in A1 to E2. Enter this anywhe =INDEX($A1:$E1,5-(COLUMNS($A:A)-1)) Copy down one row, then select the 2 cells and copy selection across 5 columns. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "SteveC" wrote in message ... I have this: 2004 2003 2002 2001 2000 10,862 9,231 7,972 6,448 5,028 Is there a quick way to make it this: 2000 2001 2002 2003 2005 5028 6448 7972 9231 10862 thanks... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Horizontal?
Thank you all. Never noticed that option button before...
"Ron Coderre" wrote: Try this: Select your data (including headings) DataSort Click the [Options] button Check: Sort left to right Click the [OK] button Set the field to sort Ascending Click the [OK] button That should sort you data in ascending order from left to right based on the column heading value. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "SteveC" wrote: I have this: 2004 2003 2002 2001 2000 10,862 9,231 7,972 6,448 5,028 Is there a quick way to make it this: 2000 2001 2002 2003 2005 5028 6448 7972 9231 10862 thanks... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
how do I transpose and paste a link in excel | Excel Worksheet Functions | |||
transpose a column into many rows | Excel Discussion (Misc queries) | |||
Transpose into a _working_ transposed array | Excel Discussion (Misc queries) | |||
TRANSPOSE() | Excel Worksheet Functions |