pivot and group the column in Power BI power query

[pang22]

Hello,

I have a table below in PowerBI.

How to pivot and group the column like below format with semicolon in Power query in PowerBI?

[ryan_mayu · Accepted solution]

@pang22 

pls try this in PQ

= Table.Group(Source, {"Department"}, {{"product", each Text.Combine([Product],";"), type nullable text}})

pls see the attachment below