Hello Everyone,

I'm trying to save myself hours of going through 100's of rows of data to manually combining cells and then deleting duplicates.

I'm trying to locate a macro that would do the following:

1) Go through Column C to locate identical values.

2) If there is identical values in column C and the values in column A are different, combine both of those values into column A.

So for example, on rows 65 & 66 I'd like for there to be only 1 row for "CLAIM_NO" 525533564 with "2325 / 2337" in cell A.

Is this possible? I really appreciate the help.

Combining cells.jpg