asked on

Merge a duplicate row based on the data of one column.

Dear Excel/VB Experts,

I am trying to right a macro in Excel that will help cleanup the duplicates in my workbook. I have some rows with a duplicate field and would like to have the first occurrence of the duplicate deleted and replaced with the second along with all the fields after it.

For example:

(before)
name phone email address
someone 11111111 hbdfk@
hbdfk@ 12 jjj ave
Someonelse 33333333 dsds@
dsds@ 23 jjj blvd

(after)
name phone email address
someone 111111111 hbdfk@ 12 jjj ave
someoneelse 333333333 dsds@ 23 jjj blvd

Is this possible??

Thanks in advance.

Ardhendu Sarangi

Hi,
couple of questions -

1. are the duplicate entries listed in consecutive rows in the file?

2. What is the key (field) used to identify duplicate records?

Can you please post a sample sheet?

thanks,
Ardhendu

Tim

ASKER

Yes and yes.

The field is "CX."

Thanks.
Sample.xlsx

Tim

ASKER

Here is the desired outcome of that sample sheet.
Sample-of-Desired-Outcome.xlsx

ASKER CERTIFIED SOLUTION

Ardhendu Sarangi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial