Remove duplicates only if the duplicate values contain a certain text

Dear Watkinnc,

Thank you for the solution, it is working, however I am trying to avoid duplicating columns or tables because I have a database that has almost 700.000 records and it is getting slower and slower with each modification like this. I am looking for a solution that doesent need anly column addition or query duplicaiton. I need also to take in consideration an another column.

The original data looks like this:

StoresArticle

And I need it transformed to this:

StoresArticle

I would need a code to add it in one step without addin and the removing columns or duplicationg queries.

Saple file: Dropbox link to sample file 

Thank you,