View Single Post
  #1   Report Post  
Spiderman
 
Posts: n/a
Default sorting data across multiple columns

I have lets say 10 columns each labeled , A, B, C, through J.
Each column contains 10 random serial numbers
How can I sort the 10 columns in ascending or descending order so that all
numbers in the 10 columns are sorted within the 10 rows in each column,
from this:
A B C D .....
10 23 24 19
2 7 18 21
17 12 11 18 ETC..

to this:
A B C D...
1 6 11 16
2 7 12 17
3 8 13 18
4 9 14 19
5 10 15 20