Combine multiple distinct rows values in one cell
I am trying to combine the distinct value from multiple rows in a column with Beast mode.
Here is an example of my file:
|Field A||Field B||FieldC|
I would like to have:
|Field A||Field B|
|A||111, 222, 333|
In this case I have a concat but I would also need to do a distinct sum potentially.
Any ideas on how I can achieve this.