How to merge duplicate rows in Excel

Learn different ways you can combine values or sum numbers that refer to the same record in Excel.

Feel free to download Combine Rows Wizard:

[JoseJupiter]

Subscribed! You're a wizard!!! The value from the free tool is crazy!

[Jaiysful]

You lovable genius. The two IFs you did to combine duplicate rows whilst concatenating unique values is CRAZY USEFUL. Thank you

[carlosedu]

Oh my God, you literally saved my job. I was having some trouble with a huge client list with more than 10000 lines... And your video showed me the way. Thanks and God bless.

[UberJPS]

Excellent and helpful video. In helper column 1, when combining text, changing from C1&", "&B2 to C1&CHAR(10)&B2 will add a line break instead of comma, which looks really good. Follow-up with a wrap text command on the column. To use this on multiple columns where only one column has the list that needs to be combined, follow the instructions for "merged values" and then filter on that helper column 2 to select only merged values. Copy and paste the resulting table values.

[webemart]

Thanks for your kind support. We need people like you on the web who help others in great detail.

[kai]

Love this, tutorial, the best I've come across in years.

[pantehamamouri]

One of the most helpful videos ever! Thank you!!

[marcuc.]

Thank you! Very concise and clear instructions made this tutorial super helpful!

[pqnucec]

You saved me days of hard working.. really... work smart not hard

[regularlifeinuhd]

OMG! I was looking for this function. Thanks for this tutorial. You're awesome!

[faizehamzatoursumrah]

Appreciating efforts as always. Thanks

[missybol]

Thank you for this, you saved me alot

[dastageera]

Very very helpful and it can save my time, thanks sister great!!!

[tonyquinn]

Thank you, it was the linking of the duplication of author to multiple filter I needed, easycto follow:)

[tebohomotsemme]

Wow Wow This video has made my life easier... Thanks for uploading

[pqnucec]

Thank u you've done a great service to me, I'm in your dept .. love u

[mttechaia]

Example at 3:20. What if instead of ", " i want to store data in different cell. Can you help?? Store data into the next cell rather than on the same cell seperated with,

[DrMohanBahuguna]

nice video. can you plz type all the commands here as the =if(.... are not so clear. regards,

[LauraMelle]

I followed your method in 2:39 to list page numbers of an index so if something appears on more than one page it would appear as (23, 127, etc.) however, I ended up with many random repeats (i.e. 23, 23, 127, 127). Not all of them have repeats, but most do. How can I fix that?

[gmagam]

I figured out how to remove duplicates and consolidate number. Howver im stuck on dates. I have to leave the dates that correspond to each accout but when i consilidate data some of the dates get messed up. Anyway around this?