Merging data from duplicate rows in Power Query

[RMDNA]

Hi all,

I've run into an issue where I need to remove duplicates keys, but keep the row information.

As you'll see below, I have a duplicate value for DateLocation key 62446, because it has two different survey types. I don't care about survey type, so I need to roll up that info into a single entry (i.e. a single 62446 entry with 2 surveys, 2 promoters, etc.).

Any assistance?

[Ashish_Mathur · Accepted solution]

Hi,

Select the DateKey and DateLocation columns, right click and select Group.  Now select the aggregation function which you want for each column.

Hope this helps.

[RMDNA]

@Ashish_Mathur,

Perfect, thank you. I've always used Group By to find duplicates, but never to merge them before.

[Ashish_Mathur]

You are welcome.