Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
MSMKM
Helper I
Helper I

Power query question

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 ?

 

2 REPLIES 2
Vijay_A_Verma
Super User
Super User

Insert this step

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

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!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.