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 ?