Merger Rows in columns Power Query

[Anonymous]

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

[v-piga-msft]

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.

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.

Best  Regards,

Cherry

[Anonymous]

Thanks for the feebback Cherry

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

[v-piga-msft · Accepted solution]

Hi @Anonymous,

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

Best Regards,

Cherry