MATLAB Answers

Sort and match data in a table

10 views (last 30 days)
Julian
Julian on 10 Sep 2019
Commented: Julian on 10 Sep 2019
Hi,
i basically have a table with two collumns.
Col1 Col 2
Label1 9
Label2 8
Label3 6
Label1 5
Label2 5
To analyze this I want to have a table which is basically something like this.
Label 1 9 5
Label 2 8 5
Label 3 6
Then i want to export this to Excel. This is why i thought it would be best to work with tables. Also because in the code before I used a lot of findgroups and splitapply, thats why the format was pretty nice. But right now i'm really stuck. I think there should exist a fairly easy solution, but i don't really see it.

  0 Comments

Sign in to comment.

Accepted Answer

Julian
Julian on 10 Sep 2019
You might consider
groupsummary(D, 'Col1', @(x){x})
where D is table containing your data. This does leave a "ragged right" cell array containing differing lengths and you will need to pad it if you want a uniform tabular representation.

  1 Comment

Julian
Julian on 10 Sep 2019
Yes this worked just fine for me, thank you very much :)

Sign in to comment.

More Answers (0)

Products


Release

R2018a

Translated by