How to merge data with different product names of the same product

Hello,

I scraped about 10 shops with thousands of products. The products in the different shops are the same but the product names differ slightly so that I can't merge the tables. Unique Item numbers are not available too.

I really don't know how I can merge the data of the 10 shops in one table when so many different name types of the same products are used. Actually I want to have all the results of one product in one row

Anyone here who had the same problems?
Thanks :slight_smile: