Reverse Transpose?
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??)
sdmfg wrote:
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
--
Dave Peterson
|