Column/row reversing in excel

[pban92]

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!

[Colin Legg]

Here's one easy way: use a temporary helper column.

In a spare column (the "helper" column), type in 1 for the first row, 2 for the second row and then fill it down the column. Then sort the entire data set by that column (largest to smallest), clear the helper column and then you're done.

[pban92]

That's it! Easy yet efficient! Thanks dude!