Forum Discussion
In Power Query Editor, how to remove the duplicates while also removing the original
For that, you need to do an extra thing.
In step 1 of grouping, go to Advance section and add an aggregation to get all rows. Something like this:
2) Then filter out the rows having Duplicates count as 1 as below:
3) Then expand other columns as below:
The end output will give you all your required columns.
Hi Anonymous ,
Please check the latest reply of PC2790 . It should show you what you want:
PC2790 wrote:
For that, you need to do an extra thing.
In step 1 of grouping, go to Advance section and add an aggregation to get all rows. Something like this:
2) Then filter out the rows having Duplicates count as 1 as below:
3) Then expand other columns as below:
The end output will give you all your required columns.
If this doesn't work, please let us know.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.