How to manipulate product CSV file so that images are in one cell, comma separated

[monero]

When exporting the products file as a CSV, I cannot figure out a way in Excel or other to take the multiple products image URLs on multiple lines, and put them all in one cell, separated by commas. I have them sorted by position.

Excel gurus out there? My sheet only has SKUs, Image Src and Image Position columns.

Thanks in advance.

[Dirk · Accepted solution]

Hey, @monero 

The concatenate function in excel should help you accomplish this. I found a youtube video that will show you how to accomplish this. Right around the 2:10 second mark it's discussed.

If there is anything else I can help you with, please let me know.

[monero]

Thank you so much. Didn't know about textjoin and how it can skip over empty cells.

[monero]

Actually, it has one flaw unless I am doing something wrong. The formula will begin producing erroneous data unless all products have the same number of images.

[monero]

What I ended up doing is get the data from an app that does eBay listing feeds, load into excel via get external data from the web (so I can keep it updated), manipulate the data in power query, then load into another sheet to get exactly one cell with values separated by commas.

[Dirk]

Great workaround! Glad you were able to get it worked out for your specific needs.

If there is anything else I can help you with, please let me know.

[TheTreadLife]

I have created a sheet with semicolon separated image src column, with each url separated. It will only upload 1 image per sku still. What am I doing wrong?