Is there a way to sort an array so that the order runs down a column then continues down the next column?

[Freiherr]

Thus, if I had a field of data in columns and rows like this:
Row 1 (10 8 5)
Row 2 (7 6 4)
Row 3 (3 2 1)

it would then sort (into descending order) into this:
Row 1 (10 6 3)
Row 2 (8 5 2)
Row 3 (7 4 1)

[PYS]

Hi

You can use an array function (use the key combination Shift+Ctrl+Enter)

=LARGE($A$1:$C$3; {1.4.7;2.5.8;3.6.9})

Note: adapt the separators according to you Tools▸Options▸Calc▸Formula▸Separators

See SortWithArray.ods

Regards