1

I have a document that's a recurring CSV import/export. I'm trying to concatenate images separated by ", " and using ARRAYFORMULA to make it all the way down.

The problem is, I don't know how many images there will be, but I know the maximum is 15. So if I concatenate, by for instance using A1+A2...+A15, I will end up with multiple commas at the end since I don't know how many there is.

I have this so far =ARRAYFORMULA(JOIN(", ",FILTER(B3:P3,NOT(B3:P3="")))) in A2.

Can anyone help with how I can concatenate from B2:P2 and wrap it in an ARRAYFORMULA to go all the way down?

link to my spreadsheet

0

=ARRAYFORMULA(TRANSPOSE(SPLIT(TEXTJOIN("♪", 1, 
 QUERY(TRANSPOSE(IF(B2:Z<>"", B2:Z&",", )), 
 "select *", ROWS(B2:B))), "♪", 0)))

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.