Sort the numbers in ascending order by lines

Hi
I have a spreadsheet with 14 columns and 500 rows each
I'm trying to organize the numbers in ascending order Sort command lines by Excel, but it only does one line at a time.
Is there a code to sort all rows at once?

See line painted yellow, was classified manually.
Here is a part of the worksheet as an example of what I need

There is probably a more eligant way to do this (VBA), but the attached does what you want by creating another table and using a formula =small() to sort your numbers by row. If you dont need to keep the original values, you can value (/copy/paste values) answers from the formula, and then delete the original data

Try:

Please Login or Register  to view this content.