Making a list of products contained in category

[lochoad]

I have a very simple data structure that contains 1) the unique product id and 2) the Category this product belongs to.

I need to transfer this into an aggregated view of the category whose values are the unique product id's that category represents.

Table 1:  What I have

product ID	Product Category
10	Shavers
11	Scissors
12	Trimmers
13	Shavers
14	Shavers
15	Scissors

Table 2: What I need

Product Category	Contained in
Shavers	10, 13, 14
Scissors	11, 15
Trimmers	12

Of course I have to do it dynamically as we keep adding products and categories so the ledger is massive. 

Would appreciate any help or ideas! 

[amitchandak · Accepted solution]

@lochoad , Create a measure and use in visual

concatenatex(Table, Table[product ID], ",")

Concatenatex: https://www.youtube.com/watch?v=du2HSEzng2E&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=43