How to sort a table or Excel file (.xlsx) (.csv) and sort the labels correspondingly?

Dear scholars,

I was wondering how to wrtie a code in MATLAB so sort a table based on the magnitude if numbers and then sort/move the corresponding labels as well?

I mean: suppose: a = 1; b= 2; c=3

I nead a table in this format:

a 1

b 3

c 2

Then I need to sort such a table in an ascending fashion in which sorts the labels (a, b, c) as well. The final answer should be:

a 1

c 2

b 3

Any ideas?

Answer 1

[Cris LaPierre]

In MATLAB, you would use sortrows.

name = ["a";"b";"c"];
val = [1;3;2];
T = table(name,val)

T = 3×2 table
    name    val
    ____    ___

    "a"      1 
    "b"      3 
    "c"      2 

Tsort = sortrows(T,'val')

Tsort = 3×2 table
    name    val
    ____    ___

    "a"      1 
    "c"      2 
    "b"      3