>> t = table([1;3;1;2;4;2;3], {'AAA';'AAA';'BBB';'AAA';'BBB';'BBB';'BBB'},[100;500;300;250;50;NaN;100])
t =
7×3 table
Var1 Var2 Var3
____ _____ ____
1 'AAA' 100
3 'AAA' 500
1 'BBB' 300
2 'AAA' 250
4 'BBB' 50
2 'BBB' NaN
3 'BBB' 100
>> unstack(t, 'Var3', 'Var2')
ans =
4×3 table
Var1 AAA BBB
____ ___ ___
1 100 300
3 500 100
2 250 NaN
4 NaN 50
Best Answer