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