Forum Discussion
sorting numbers
I know almost nothing about excel, i'm trying to sort numbers in ascending order, left to right i have 5 columns of numbers and 1962 rows, can i sort multiple rows at one time? I can't even make it s...
Your pic shows what I'm trying to do, I can sort one row at a time but when I do a second row my first row returns to an unsorted row.
=TRANSPOSE(SORT(TRANSPOSE(A1:C1)))
or online sql: