Is there a way to transpose and invert the order of data in Excel.
 

I have a worksheet with ascending years and I want to have the years descend.
I need to learn how to invert the data without having to manually re-enter 30
years worth of data.

Try the menu DataSort

Regards,
KL


"TransPlan" wrote in message
...
I have a worksheet with ascending years and I want to have the years
descend.
I need to learn how to invert the data without having to manually re-enter
30
years worth of data.