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?