Power query question

[MSMKM]

Hi  Team,

Real case question:- 

Name             Skill

Naveen          SQL

Naveen          Azure

Naveen          Power bi

Srinivas          MSBI

Srinivas          SQL

Srinivas          Power Bi

Result is ;-

Name             skill

Naveen          SQL,Azure,Power Bi

Srinivas          MSBI,SQL,Power Bi

Please check and confirm how we can proceed ?

[Vijay_A_Verma]

Insert this step

= Table.Group(Source, {"Name"}, {{"Skill", each Text.Combine([Skill],", "), type text}})

[ChielFaber]

I think this is what your looking for:

https://gorilla.bi/power-query/group-by-to-concatenate-text/

It will give you the result you want. It uses a group by function with the Text.Combine function. It's a really great solution. Credits to gorillabi!