Grouping the table with a cell which has multiple values

[ghost]

Hi There,

I have a scenario where one of my table columns contains multiple ENUMS

For Example: [
{ userId: 1, hobbies: [chess, sing, cook] },
{ userId: 2, hobbies: [chess, sing, cook] },
{ userId: 3, hobbies: [chess] },
{ userId: 4, hobbies: [sing] },

As of now I get the results like:

1. [chess, sing, cook]
2. [chess]
3. [sing]

** I want the table which contains a sub-table as**

1. sing: The Sub Table should have columns, userId, ...other Columns [1, 2, 4]
2. chess: should contain [1, 2, 3]
3. cook: should Contain [1, 2]

Thanks in advance.

[ReinaldoSupplyScope]

Any luck on this?