Column/row reversing in excel
Hi all,
Say I have a column as follows,
5
10
8
3
9
1
I want them to be
1
9
3
8
10
5
How do I do it aside from the stupid manual way? There must be an efficient way that can handle even hundreds of rows as long as you can select them. Remember it is not "sort by ascending or descending order". No answer is actually good enough those returned by google search. I am sure there must be an easy yet efficient way, just not easy enough for me to figure it out. Thanks!
|