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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Transpose variable rows in Column

Hi Team,

First of all, thanks for what you are doing.

 

I have a neewbie issue with Power Query :

i have this table : 

ClientContract
CLI001CTR001
CLI001CTR002
CLI001CTR003
CLI001CTR004
CLI001CTR005
CLI002CTR012
CLI002CTR013
CLI003CTR003
CLI003CTR004

 

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

ClientContract
CLI001CTR001, CTR002, CTR003, CTR004, CTR005
CLI002CTR012, CTR013
CLI003CTR003, 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 

1 REPLY 1
jgordon11
Resolver II
Resolver II

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

 

Change Source to the appropriate step name

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

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