Reverse Transpose?

  • Thread starter Thread starter sdmfg
  • Start date Start date
S

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
 
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??)
 
Hi,

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