Transpose Horizontal?

S

SteveC

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

Ron Coderre

Try this:

Select your data (including headings)
Data>Sort
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
 
R

RagDyeR

You could use a formula to reverse your data if you'd like to change
locations.

Original data in A1 to E2.

Enter this anywhere:
=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!
=====================================================

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

SteveC

Thank you all. Never noticed that option button before...

Ron Coderre said:
Try this:

Select your data (including headings)
Data>Sort
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 said:
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...
Click to expand...
Click to expand...
 
Top