Remove Duplicates Using Power Query | Excel Tips & Tricks

[@excelwithpaolo]

Hope you liked the video! What video should I make next?

[@uc7602]

Very helpful video! Thank you for sharing your experience with Excel and Power Query. Look forward to your next video.

[@excelwithpaolo]

Thanks a lot!

[@stanTrX]

Thanks. I want to remove duplicates based on one column if the other column is grouped

[@dinahany233]

in append example when i refresh it duplicates my queries any help with solution ??????? t...

[@sanjayborah9591]

Why not select only the row column?

[@PallaviChauhan91]

Thanks, this was really helpful! Subscribed

[@freddylopez1483]

I have a similar example and did the exact same thing as you and removed duplicates, but after closing power query I get an error “[DataFormatError] We couldn’t convert to Number”. How do you fix this?

[@excelwithpaolo]

Hard to say without seeing the code. Did you remove the step from the Applied Steps section?

[@cindylam9607]

What we can do if we find duplicates after the power query merges the Excel data?

[@excelwithpaolo]

Do you mean if you've added new data? Just refresh the query.

[@cindylam9607]

For example, my original data set is 100 rows. After the original data is moved to the power query editor, we do the merge and close and load to a new worksheet it becomes 110 rows.

[@FatimahOptics]

Why is it bold