Sorting Data - Multiple coluns and rows into an ordered list

I would be much obliged if someone could help me figure this out.

I have an excel sheet with 10 columns and 10 rows. Each cell contains a 6-digit number anywhere from 235764 to 387655 (invoice numbers).

Is it possible to sort the entire selection of numbers into an equal number of columns and rows but in numerical order from lowest to highest?

I want to take a sheet that looks like this:

5 4 7 3 8 9
13 2 18 1 16 6
10 11 17 12 14 15

to look like this:

1 4 7 10 13 16
2 5 8 11 14 17
3 6 9 12 15 18

Thanks!

Hi

Assuming your 10*10 table is in A1:J10, write in L1:

=SMALL($A$1:$J$10,ROWS($L$1:L1)+10*(COLUMNS($L$1:L1)-1))
Copy down and accross

HTH
lecxe

Thanks! That works. You saved me lots of time.