Forum Discussion
Solution SageMerging data from duplicate rows in Power Query
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?
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.
3 Replies
- Ashish_Mathur
Super User
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.
RMDNAPerfect, thank you. I've always used Group By to find duplicates, but never to merge them before.
- Ashish_Mathur
You are welcome.