Extract data if there are duplicates in 1 column and different values in another

Hello!

Looking to copy and paste data from one tab to another if there are duplicate values in one column but different values in another please. I have attached a sheet with an example of the before and output from the macro.


Ultimately, I am trying to compile a list of suppliers that deliver to different locations and a CONCAT of the locations.

In the example, you can see that supplier BB only delivers to one location so should be excluded from the list. whereas AA and CC deliver to multiple and should be listed with the locations noted as a concat.
There would also be more columns to copy across such as town and post code along with the address.

I hope that makes sense!

Thank you for your time.

Hi,
Updated - forgot all about that bit!

Originally Posted by Sintek

So what are the unique keys here...Col C,D,E&F combined...

C,D,E&F with G

So D, E and F will all match when C is the same i.e. it is the address for the suppler and each supplier has an individual code.

Then if that supplier has more than one delivery location (G) it means it delivers to multiple sites so should be extracted along with it's address data and the the delivery locations and pasted into a new sheet but the each supplier should only be on one line with the delivery locations in one column

Hi,

Thank you so much! I managed to tweak it to fit my sheet and it works perfectly. I am unable to add rep at the moment as I have to spread it around but as soon as I can I will add it!