I have a client that has an excel spreadsheet with about 45,000 rows.

I need to consolidate any duplicate records and merge the info so that each contact only has one record (or row).

What would be the easiest way to do this?

Thanks!

__________________
Vivi Gonzalez
www.VirtualBusinessPartners.com

Have you sorted it yet? If not run a sort by Name or account number which ever is the standard in the document.

Once you sort you will find all of the duplicates, then you can combine the duplicate information to the original cell.

__________________
Action Jackson Virtual Assistant|

First I would sort by the main data field (name, maybe) to identify if the data in the duplicates is exactly the same.

If it is Excel includes a remove duplicate record function which you can run and it will remove the duplicate rows for you.

If not, it will be a more manual process since you will need to decide which duplicate contains the data to be kept.

If you would like you can DM me and I can look at the file for you.

__________________
Cindy
www.eoseasy.comThe Chrysalis Plan

Yes, I have it sorted and even have the duplicates highlighted for me already.

I was just wondering if there's a way to merge the duplicates so that we don't delete any of the informatin.

For example... say the spreadsheet has 5 columns and the duplicate process shows me taht there are 3 rows for John Smith. The info in the 3 records will probably be different in the Notes Column. I don't want to lose any of those notes.

I think it's a manual job, but was hoping that there was an easier way to do it since there are over 45,000 rows.

__________________
Vivi Gonzalez
www.VirtualBusinessPartners.com

If you have it sorted and the only information you want to keep are the notes, Highlight the notes section and click merge. You should not loose your content, it will merge them together keeping all notes in one cell. Try it on one of them, and if it does not do what you want then click undo.

Yes, it will be a lot of work.

Good luck,
Andrea

__________________
Action Jackson Virtual Assistant|

Hi Vivi!

I absolutely love Microsoft's Help and How To pages. I discovered exactly how to do it. Here's the link that will walk you through this step by step. http://office.microsoft.com/en-us/ma...CE010741921033

Good luck and let me know if it resolves. If not, please send me a PM and I'll see what I can do to assist.

Thanks!

__________________
Kathya Kalinine
http://www.emeraldvirtual.com

sort first, they should be visible from there