Sort a table in ascending order
30 views (last 30 days)
Show older comments
Hi
How can I sort a table-type array in ascending order
For example
First mode

To:

TNX :)
1 Comment
Stephen23
on 12 Nov 2020
@Shahar ben ezra: you should transpose the way your table is arranged, otherwise it will be a nightmare to work with (both in Excel and MATLAB).
Accepted Answer
Steve Eddins
on 12 Nov 2020
Edited: Steve Eddins
on 12 Nov 2020
The answer would be relatively straightforward, as well as much more efficient, if you would orient your table the other way. With data such as yours, table is really designed to be used this way:
>> Name = ["roni" ; "tim" ; "jon" ; "lie" ; "kim"];
>> TestScore = [90 ; 45 ; 67 ; 84 ; 32];
>> T = table(Name,TestScore)
T =
5×2 table
Name TestScore
______ _________
"roni" 90
"tim" 45
"jon" 67
"lie" 84
"kim" 32
Then you could sort the table using sortrows:
>> T2 = sortrows(T,"TestScore")
T2 =
5×2 table
Name TestScore
______ _________
"kim" 32
"tim" 45
"jon" 67
"lie" 84
"roni" 90
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!