MATLAB: Sorting rows only with name of column

sorting

Hi guys, my question is:
I have a table with 5 rows and 10 columns like this:
 Datetime           Var1               Var2               Var3        Var4        Var5      
  ________________________________________________________      
    01-01-90        0.025001           0                0.058841     0      0.059898    
    01-02-90        0.025318           0                0.068993     0      0.067252    
    01-03-90        0.025318           0                0.074108     0      0.074613    
    01-04-90        0.025318         0.019803     0.10536       0      0.10008   
    01-05-90        0.03774          0.020203      0.1372         0       0.16455     
......... etc
My question is: How do I sort each row by column name and get a result like this? 
Datetime       1        2         3         4          5
___________________________________
01-01-90    Var5   Var3    Var1   Var2     Var4 
01-02-90    Var3   Var5   Var1    Var2     Var4 
01-03-90    Var5  Var3   Var1     Var2     Var4 
01-04-90    Var3   Var5   Var1    Var2     Var4 
 01-05-90    Var5   Var3   Var1   Var2     Var4 
.......... etc
thanks a lot.

Best Answer

Try this:
% Setup table.
m = randi(9, 10, 5); % Random integers
dateTimes = repmat(datestr(now), 10, 1)
t1 = table(dateTimes, m(:, 1), m(:, 2), m(:, 3), m(:, 4), m(:, 5), 'VariableNames', {'Datetime', 'Var1', 'Var2', 'Var3', 'Var4', 'Var5'})
% Now we have our input table and we can begin
% Get the variable names from table t1.
t1VariableNames = t1.Properties.VariableNames
% Make an output table called t2.
t2VariableNames = {'Datetime', 'Pos1', 'Pos2', 'Pos3', 'Pos4', 'Pos5'}
t2 = table("Datetime", "Pos1", "Pos2", "Pos3", "Pos4", "Pos5", 'VariableNames', t2VariableNames)
% Now sort each row by columns:
for row = 1 : size(t1, 1)
	[~, sortOrder] = sort(t1{row, 2:end}, 'descend');
	t2(row, 2:end) = t1VariableNames(sortOrder + 1);
	t2(row, 1) = t1(row, 1); % Transfer datetime column.
end
% Display result in command window:
t2
You get:
t2 =
10×6 table
Datetime Pos1 Pos2 Pos3 Pos4 Pos5
______________________ ______ ______ ______ ______ ______
"12-Jun-2020 08:32:30" "Var4" "Var1" "Var2" "Var3" "Var5"
"12-Jun-2020 08:32:30" "Var2" "Var1" "Var3" "Var5" "Var4"
"12-Jun-2020 08:32:30" "Var5" "Var4" "Var1" "Var3" "Var2"
"12-Jun-2020 08:32:30" "Var1" "Var2" "Var4" "Var5" "Var3"
"12-Jun-2020 08:32:30" "Var2" "Var5" "Var3" "Var4" "Var1"
"12-Jun-2020 08:32:30" "Var3" "Var1" "Var2" "Var4" "Var5"
"12-Jun-2020 08:32:30" "Var2" "Var3" "Var1" "Var4" "Var5"
"12-Jun-2020 08:32:30" "Var1" "Var4" "Var2" "Var3" "Var5"
"12-Jun-2020 08:32:30" "Var2" "Var3" "Var1" "Var4" "Var5"
"12-Jun-2020 08:32:30" "Var3" "Var4" "Var1" "Var2" "Var5"
Related Question