Grouping the Values with a comma by >each equal< Category >only for< each equal name

[vanessza93]

Hello guys

can someone help me with another problem I got here? 

Basicaly have this table and want to output it like this

Grouping the Values with a comma by >each equal< Category >only for< each equal name

[Rayshin · Accepted solution]

@vanessza93 

Here is an approach that you can make it work:

1] Group By on the first two columns
2] the remaining column is set to all rows

Now the data is segregated, you would need to Sort( distinct())
After you should see a list of values, make sure they are all text (change data type to text)
Then Text.Combine( list, ", " )

To wrap it up:

GroupBy Name, Category with All Rows