I have this table : enter image description here

where i want to join all data in each row start from column D to last column. I want the output just like in that C2:C5

I use this formula in C2 :

=JOIN(",",filter(D2:2, D2:2<>""))

and copy paste down for C3:C5. This is working just fine but i'm looking the way to make it as a single formula using arrayformula() in C2.

Is it possible ?

1 Answer 1


Use a query smush like this:

        query( transpose(D2:ZZ), "", 9^9 ) 
    " ", 
    ", " 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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