How to sort the whole table?

Question

excel

Table

You need to sort it in ascending order.
Built-in functions sort rows / columns separately, but you need the whole array

Answer 1

Alas, the usual variety will not work here. It is possible to try through Macros/VBA.
You can do this:
1) push everything into one column
2) Sort it
3) Manually cut from 39 to 79 and paste it next to the column. Repeat ~8 more times.
If you need to automate it. you need to do it once with handles and write it down ( Record Macros ) and then edit the macro so that there is no rigid binding to the cells. Here you need to use something likeSelection.End(xlDown).Select

Answer 2

"Data" menu - "Sort" command.
Sort by different columns, criteria, with different nesting

Answer 3

Ascending what?

Answer 4

Do you have equal columns?
Well, make another one, output the maximum of the entire line into it with a formula and sort by it ...