Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel-merge duplicate rows

Jun 3, 2004 2:23AM PDT

Windows XP Home Edition; Excel 97 SR-2
I have 50 plus Excel Spreadsheets with Contact Name, Address, etc. I use Advance Filter to find duplicates. Now, how can I merge?
HAVE:
Contact Company Phone City State
John May ABC, Inc. 555-555-1212
Contact Company Phone City State
John May ABC, Inc. York NE
WANT:
Contact Company Phone City State
John May ABC, Inc. 555-555-1212 York NE

Discussion is locked

- Collapse -
Re:Excel-merge duplicate rows
Jun 3, 2004 4:10AM PDT

Bite the apple, switch to MS Access, and STRUCTURE YOUR DATA, then copy/paste or retype everything.


Kees

- Collapse -
Re:Excel-merge duplicate rows
Jun 3, 2004 9:56AM PDT

I cannot really tell from your message the format of the data- is it divided in columns with Contact in the first, then Company, then, respectively, Phone, City and State in the subsequent columns? Or is all the information in one cell?

Would the CONCATENATE()function be of use to you? Perhaps embedded into an IF() function?

Or IF() funtions directed to different worksheets?

Or perhaps Copy/Paste of the Columns (via insert columns)?

If you are still struggling with this by the time you read this, perhaps you can rephrase your question so that we can be of more help.