Merging rows with similar data?

Do you have a sample file that you can upload?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

I can prepare one, I will have to remove any sensitive data beforehand though, I will get to it as soon as I have a free 20mins from work.

Thanks for the help!

EDIT: I have attached a small portion of the data, as you can see, not all rows have a duplicate like in the example.

Thanks again!

A few questions -

1. Will the data always be sorted prior to running the macro or can we include the sorting in the code?

2. Is it always column D that will have the variants in info?

3. I am guessing that your original data will have headers. Your sample file doesnt and when you try and make the code work on your original, you will face issues.

4. Should columns A & B be compared together to arrive at duplicate/matching entries?