Power query question

Question

Hi&nbsp; Team,&nbsp;&nbsp;Real case question:-&nbsp;Name &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SkillNaveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQLNaveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AzureNaveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Power biSrinivas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MSBISrinivas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQLSrinivas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Power Bi&nbsp;Result is ;-Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; skillNaveen&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL,Azure,Power BiSrinivas&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MSBI,SQL,Power Bi&nbsp;Please check and confirm how we can proceed ?&nbsp;

chielfaber · Answer

I think this is what your looking for:&nbsp;https://gorilla.bi/power-query/group-by-to-concatenate-text/&nbsp;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!

vijay_a_verma · Answer

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

Forum Discussion

Power query question

2 Replies

Related content

Power Query/Overwrite cell question

Question about Power Query functions

Power Query Question

Dataverse query performance question

Excel Power Query Question