Video how to: consolidate duplicate rows keeping unique data only

Watch our 2 minute video to learn how you can quickly merge duplicate rows into one using Combine Rows Wizard add-in.

Combine Duplicate Rows Wizard for Excel merges data from multiple duplicate rows into one quickly and perfectly. It takes just 3 simple steps to combine all values from identical rows based on a selected key column or several columns. The wizard can join all entries or pull unique data only skipping duplicates and empty cells.

Combine Duplicate Rows video transcript

When you look at some tables you get an Excel, you know there should be a simple way to make the data fit for further work. Combining duplicate rows that have unique records is one of such challenges.

My task is not only to simply delete the duplicates. I need to keep the unique records and merge them all to one row. You don't have to play "Find 10 differences to complete the task". Combine Rows Wizard can do this in three simple steps. Like here we have a table with our customers' names and orders. There are different items that belong to the same person on different rows. In the end, I want to have a row per name with the full list of items this person wanted. That's when "Combine Rows Wizard" comes into play.

When I start the add-in by clicking on its icon, it picks the range with all my data. I can change it, of course, if I need to. I'm good with processing the entire table but I prefer to keep the original. So I take the Backup copy option and follow to the next step.

Here I pick the column with the main information which is the Name in my table. This means the add-in will look for the same names to bring the rest of information for this person to 1 row.

I can choose what information to keep on the next step. Here I select columns with the records I want to merge. So the add-in will look through these columns and take all values from different rows that belong to the same name. You can enter your own delimiter for these values or choose among the popular ones in the list. If you have other columns you want to select, you can save some time by using this checkbox. Fields have the same delimiter picked by default. You can keep on with the unique values by taking the Delete duplicates option. Or you can keep all records by unchecking it.

That's it! Click Finish to see all the records merged into 1 row with the name they belong to.

You can give Combine Rows Wizard a try by downloading its evaluation version. It is fully functional.

If you have any questions please write to support@ablebits.com.

Thank you for your attention!

See also:

4 Responses to "Video how to: consolidate duplicate rows keeping unique data only"

  1. Kyle says:

    How do I perform this same function in excel 2011. I cannot seem to find the combine rows feature.

  2. Muveen says:

    I have in column A

    1 Cast
    2 Crew
    3 Hiring
    4 Cast
    5 Hiring
    6 Crew

    I need these unique CAST CREW AND HIRING in another column without delete in column A entries.

    Ex: I need (after formula)

    1 Cast
    2 Crew
    3 Hiring

    Is it possible by formula?

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Ultimate Suite 2018.5 for Excel
60+ professional tools for Excel 2019-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard