View Single Post
 
Old 01-25-2011, 01:10 PM
pban92 pban92 is offline Windows Vista Office 2003
Novice
 
Join Date: Jun 2010
Posts: 7
pban92 is on a distinguished road
Default 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!
Reply With Quote