MATLAB: How to change 3d array to 2 d array

3dcell arraysMATLABsorttable

i have table
A 1 N
B 1 J
C 1 N
A 2 J
B 2 N
C 2 J
I want change that table to
A B C
N 1 2 1
J 2 1 2

Best Answer

a = ['A'; 'B'; 'C'; 'A'; 'B'; 'C'];
b = [1; 1; 1; 2; 2; 2];
c = ['N'; 'J'; 'N'; 'J'; 'N'; 'J'];
T = table(a,b,c)
T_new = unstack(T,2,1)
results in:
T =
  6×3 table
    a    b    c
    _    _    _
    A    1    N
    B    1    J
    C    1    N
    A    2    J
    B    2    N
    C    2    J
T_new =
  2×4 table
    c    A    B    C
    _    _    _    _
    N    1    2    1
    J    2    1    2
Related Question