Arrayformula elements for google () and split () files

Question

Does anyone know how to massage the formula of this function join?

My formula is not as complicated as here. ArrayFormula a Filter in a join (Google Sheets)

It does not contain a function filter, so I'm not sure which of this answer applies and does not apply.

I want to build a formula: =if(isblank(B2),,join("," ,B2:I2))

Using the usual method to create an array does not work:

=ArrayFormula(if(isblank(B2:b),,join(",",B2:b:I2:i)))

Also for partitions I have split(B2, ",")

=ArrayFormula(split(B2:B,",")) executes only the first line

Answer 1

Perhaps try:

=ArrayFormula(if(len(B2:B), B2:B&C2:C&D2:D&E2:E&F2:F&G2:G&H2:H&I2:I,))

or

=ArrayFormula(substitute(transpose(query(transpose(B2:I),,rows(B2:B)))," ",""))

or, if you want a space between concatenated values:

=ArrayFormula(trim(transpose(query(transpose(B2:I),,rows(B2:B)))))

To use split () in arrayformula, a workaround can be found here