I need to merge two csv files.
- First file has rows with product info, one product each row, there is a product number in the row.
- Second file has image URLs, one URL each row. The images are product images, up to seven images for each product. The product number is a part of the URL.
I need the image URLs to be imported into the first file. All images for each product should be in one cell on the product row, URLs separated by |. Like this URL|URL|URL|URL.
Product number is unique.
Example product number: EI109T
Last part of image URLs: /EI109T/EI109T-1.jpg, /EI109T/EI109T-2.jpg...