I’ve been web-scraping the product data from multiple different sites into google sheets.
I’m having an 3 issues
Issue 1 the product is called different names on different sites.
Here’s a example
Lets say I have three different google sheets each representing a different site and I’m combining them into one.
Site A Amd Ryzen 16 core 5950x
Site B Ryzen 16 core 5950x
Site C Amd 5950x
Issue 2 I don’t know if this matters as much but my web scraping is also picking different products with the same issue
Site A amd Ryzen 6 core 5600x
Site B Ryzen 6 core 5600x
Issue 3 I would like to merge all similar columns into one row.
So one amd Ryzen 5950x and with a column of 3 url links to site a site b and site c
I’m sorry this is long I’ve spent 7 hours to no avail trying to figure this out.
A similar data structure pcpartpicker.com but not