Transpose variable rows in Column

[Anonymous]

Hi Team,

First of all, thanks for what you are doing.

I have a neewbie issue with Power Query :

i have this table : 

Client	Contract
CLI001	CTR001
CLI001	CTR002
CLI001	CTR003
CLI001	CTR004
CLI001	CTR005
CLI002	CTR012
CLI002	CTR013
CLI003	CTR003
CLI003	CTR004

and i would like to aggregate by Client and have this :

Client	Contract
CLI001	CTR001, CTR002, CTR003, CTR004, CTR005
CLI002	CTR012, CTR013
CLI003	CTR003, CTR004

i tried with transpose function, divided function but it's not working.

Do you have an idea how we could do that?

Thanks a lot for your help

Br

Marcolen 

[jgordon11]

= Table.Group(Source, {"Client"}, {{"Contract", each Text.Combine(_[Contract], ", ")}})

Change Source to the appropriate step name