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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Merger Rows in columns Power Query

Hi Experts

 

is it possible to merger rows of data in a column similiar to excel in power query.....

Before:

 

Division	Location
9	New York
9	London
9	Toronto
10	New York
10	London
10	Florida
10	DC
8	Toronto
8	New York
8	London

After

 

Division	Location
9	New York
	London
	Toronto
10	New York
	London
	Florida
	DC
8	Toronto
	New York
	London

 

1 ACCEPTED SOLUTION

Hi @Anonymous,

 

You could have a good look at this video which shows the detail steps.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

 

I'm afraid we may not transform your data model to be the same as you expected in Editor Query.

 

We could merge multiple rows into one row like below.

 

Capture.PNG

 

If you want get this output, you could refer to the expressions below.

 

   #"Grouped Rows" = Table.Group(#"Changed Type", {"Division"}, {{"Count", each _, type table}}),
   #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Text.Combine([Count][Location],",")),

 

Howeverm, I suggest you could create a matrix to show the data like below which is similar to your desired output.

 

Untitled.png

 

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanks for the feebback Cherry

 

Capture.PNG

 

What are the steps to get the above......

Hi @Anonymous,

 

You could have a good look at this video which shows the detail steps.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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