Sort and Arrange Matrix for Lookup Table - monotonically increasing

Hi, I want to prepare my data for a lookup table. It must be monotonically increasing: How can I do that ?

For example:

Before:

NAN  6  1  8  3  12  10  9
8  Q  O  R  P  U  T  S
1  C  A  D  B  G  F  E
4  J  H  K  I  N  M  L
13  L  J  M  K  P  O  N
9  X  V  Y  W  B  A  Z
12  E  C  F  D  I  H  G

After:

NAN  1  3  6  8  9  10  12
1  A  B  C  D  E  F  G
4  H  I  J  K  L  M  N
8  O  P  Q  R  S  T  U
9  V  W  X  Y  Z  A  B
12  C  D  E  F  G  H  I
13  J  K  L  M  N  O  P

Answer 1

[Walter Roberson]

After = sortrows(sortrows(Before).').';

[Marv]

Thanks, but this will sort all data. I want the left column (X-Values) and the top row (Y-Values) to stay where they are. With your command the first row is in the last row now, because "NAN" is in the top left data.

How can I fix that ?

[Marv]

To make it more clear: 1 Step, sort in X-values: in the example above the numbers at the left column; 8, 1, 4, 13, 9, 12 should be sorted by increasing order. According all Z-values in the table should be moved, which means the whole row should be moved.

Then the 2nd step is to do that with Y-Values, there the whole column should be moved (increasing order for the values in first row)

[Guillaume]

@Marv, Walter's answer does exactly as you want (assuming your data is just a matrix of numbers, unlike your example). It first sorts the rows by the first column, then the columns by the first rows. NaN does not have an ordering, so sortrows puts it at the end.

If you want the NaN row/column to come first, simply replace the NaN by -Inf.

[Marv]

    Great ! Thank you very much, it works :)

How can I export these sorted values for the Lookup Table ?

For example:

Table Data = Value_Matrix11,...,Value_MatrixRow1N;Value_Matrix21,...,Value_MatrixRow2N]

Breakpoint1 = [Value_Matrix1,...,Value_MatrixN]

I look for ouputted the values in correct format, so that I just have to copy paste it in the lookup table editor :)