View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Reverse Transpose?

Hi,

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

--
Thanks,
Shane Devenshire


"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