how to concatenate the names selected in google sheet?

Question

Hi everyone,

I want to use a formula to concatenate the name that has been selected in the checkbox by using the delimiter "+". The expected output is highlighted in yellow in the screenshot above. Ideally the formula can be an ARRAYFORMULA in cell F5 instead of making entire column F full of formula. Any help or advice will be greatly appreciated!

Answer 1

See if this helps

=ArrayFormula(substitute(trim(transpose(query(transpose(if(B5:E, B4:E4,)),,9^9))), " ", " + "))