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

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

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

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

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