Change values in columns in an array so that they are in ascending order

[DickCun]

Convert the values in the following matrix:

so that they are in ascending order thusly:

Thanks for anyhelp provided!

Dick.....

[ValeryOchkov]

See please the csort function.

[MikeArmstrong]

I cannot see the images you have uploaded please upload worksheet.

[Werner_E]

Images cannot be inserted in the context of a post via cut and paste - it only looks OK until you add the reply! You have to use the appropriate button to insert images.

To attach files you have to chose "Use advanced editor" at the upper right.

Have you looked up in the help the various sort commands? (sort, csort, rsort)

[DickCun]

Sorry about images not showing up......

Here is the worksheet I have been using to resolve this issue......

Dick.......

[ValeryOchkov]

My variant:

[Werner_E]

Here is my appraoch.

As you want every column to be sorted on its own you can't use csort but have to use sort() and the column selector.

[Fred_Kohlhepp]

column by column

[DickCun · Accepted solution]

Thanks all for your help!!!!