Forum Discussion
Solved
Merging 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 t...
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.
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.
Perfect, thank you. I've always used Group By to find duplicates, but never to merge them before.
You are welcome.