How can I convert this table to a cell array as shown in the screenshot?

I have a CSV file that looks like this and I would like to convert it to two cell arrays by id.

One array contains all "t" of the same id (shown above), and the other array contains all "measure" of the same id as shown below

.

Answer 1

[Andrei Bobrov]

tout = varfun(@(x){x(:)'},T,'GroupingVariables','id');
C = tout{:,3:end};

measure = C(:,1);
t = C(:,2);

[madhan ravi]

+1

[zhongjie]

Thank you! It appears to give a 2x1 cell rather than the 1x2 I was looking for. Also the elements inside the cell need to be transposed. But I can do the rest myself. Thank you very much for the answer!

[Andrei Bobrov]

I'm fix (about transpose).

Maybe accept it answer? Or ...

[zhongjie]

Sorry I'm new to this community, didn't really notice that "Accept this answer" button. My bad!

Answer 2

[Anmol Dhiman]

Use the following commands

T = readtable('filename.csv')
c{1} = T{T.id==1,'measure'}
c{2} = T{T.id==2,'measure'}

[zhongjie]

Thank you very much for the answer!