How to combine and separate rows using comma, based on similar interests

[Dee]

Hello, I have a table that I would like a formula/Suggestion that would assist me to achieve the grouping of customers based on similar interests.

Example:

User Products

1  |   A

2  |   A

1  |   B

2  |  C

3  |  B

My desired output is

A |   1,2
B |  1,3

C |  2

Is there an easy way to achieve this as a calculated column without necessarily having to use   M?

Thanks for any help:)

[ryan_mayu · Accepted solution]

@Dee 

you can do that in PQ

= Table.Group(Source, {"Products"}, {{"User", each Text.Combine([User],","), type nullable text}})