If you have a spreadsheet that has a column with a comma-separated list of values (like URLs), you can easily combine them and create a separate row for each one in Google Sheets using a formula like this:
=TRANSPOSE(SPLIT(JOIN(",", Sheet1!B2:B), ","))
The formula above references column B of Sheet1, where each row's Column B is a comma-separated list of URLs for each product on a Shopify store.
Here's what the formula does:
JOIN(",", Sheet1!B2:B): This part of the formula combines all …