How to make data upside down with a single click in MS Excel 2007 like shown in the below picture?
after making upside down
As well how to reverse it back with a single click?
I don't think Excel can do this on its own, but I found this macro
You can do this with an array formula (ie without VBA)
See Pearson's Reversing The Order Of A List
If your data was in A1:C3 then
Try adding numbering to a column to the right of the data, like this:
Select the data, then do a descending sort by the 4th column.
Then feel free to delete the fourth column.