Remove duplicates without losing any info | Excel Power Query

Learn to easily merge and group duplicates in Excel using Power Query's built-in function. Say goodbye to losing important information and hello to a cleaner, more organized dataset in this step by step tutorial for beginners. Maximize your data's potential with Power Query.

If you enjoyed this video, please like and subscribe to my channel.

Also, if you have any tutorial requests, leave a comment below!

[excelwithpaolo]

Subscribe for more Excel Power Query tutorials!

[Oldwood-pb]

opened a 4th chakra in my brain and I finally managed to do what I wanted to after 2h of struggle, thank you sir

[cuba_rj]

I am trying this to sum overtime sheets containing duplicated dates. Thanks.

[ashkanfb]

This video saved me after many hours of struggling with power query - thank you!!

[ahmathsibi]

I was searching for this almost for a week.Thank You

[SndfOmar]

Awesome! Using that trick to fool PQ into summing Emails then edit the code. Glad to subscribe. 👏

[Tamrr]

Excellent video well explained, I appreciate that Paolo!

[JLVN]

This was extremely helpful as I had duplicate contact emails and didn’t want to lose any.

I also have numbers I’m trying to combine but Text.Combine doesn’t work on numerical values. Any tips?

[mans]

This is awesome, thanks! What about if you have multiple duplicates, like email addresses AND phone numbers?

[pankajadhikari]

Awesome...How about adding email id in new column rather than separating it through ;? Also how about if we have numbers & not text?

[mosessule]

Hi, i have an issue though, what if i want all the names merged as one name and then emails as one email, considering that my data has the same name and emails, the name on the left and mails on the right but some names are not paired to their mails, but are paired to their mails as u scroll down. I don’t know if my explanation is clear enough. Thanks

[MoonShine-bscl]

Pls make a video in power bi desktop power query if we have 2 tables and i need only the date column from other table, but while performing merge my dataset is getting duplicated. When i hav many to many in both the tables how to perform merge.

[vidsbyme]

Thank you. How would I rather than combine but put the 2nd email into another column under the same name/row?

john doe(row 1), $xxxx (column b) $xxx (column c)
john doe (row 2), $xoxoxo (column b), $oyoyoy (column c) I want to move row 2 (because it is the same name), column b & C up to column D & E row 1. I have hundreds of rows some have two or more duplicate names. I am trying to create a mail merge to send out email payment reminders and only want to send one email with all their payments listed. Thanks.

[computerdaddymultimedia]

Is there a way to add a new source of data, but have the query "bypass" any row that would cause a duplicate?

[ychvjdf]

What if you want to do the same but instead of different emails, its client ID numbers? Is there a different code I can use?

[gaara]

Hello. But how can I remove duplicates from only 1 column?