One last question. Say I had 2 or more columns with exact data (column A and B), but one with distinct that I would use this macro for. How do I change the syntax to qualify to look at more than one duplicate column and copy those rows too. Example:

Gary1 12345 Gold
Gary1 12345 Silver
Gary1 12345 Bronze
Jim1 54321 Gold
Jim1 54321 Silver
aaa1 09876 Gold

To be:

Gary1 12345 Gold Silver Bronze
Jim1 54321 Gold Silver
aaa1 09876 Gold

Again...thank you so much for the help so far. I really appreciate the time !