View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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...