I have an Excel table which displays 2 entities. Because
Entity A contains multiple
Entity B, I have one row for each combination of A and B, in a cartesian product.
What I need is to transform this table in such a way that the columns from
Entity A will be distinct, and I need to concatenate the values of
Here we got 2 tables, the first one is my original. On the second one, the first few rows are grouped/concatenated exactly like I need it.
What is the best way to achieve this grouping/concatenation?