Reverse Transpose?

[sdmfg]

Can you reverse transpose an array of data?

For example, I have a row of date headers that is in this order:
10/1, 9/1, 8/1, 7/1

I would like it in this order:
7/1, 8/1, 9/1, 10/1

transpose will only convert it to a column instead of a row. Is there a
function to do this operation?

Thanks,
Scott

 

[redbird]

Easiest way would be to hilight headers and sort ascending

 

[Spiky]

See this:
http://www.cpearson.com/Excel/lists.htm#ReverseOrder

 

[Dave Peterson]

If you select the range to sort, you can use Data|Sort (xl2003 menus).
Then click the options button and sort left to right.

(These are dates just formatted to appear like this, right? They're not text
values??)

 

[ShaneDevenshire]

Hi,

Highlight your data with the heading (or just the headings) and choose Data,
Sort, Options, Sort Left to Right, OK, Ascending.