View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
redbird redbird is offline
external usenet poster
 
Posts: 8
Default Reverse Transpose?

Easiest way would be to hilight headers and sort ascending

"sdmfg" wrote in message
...
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