I have the range of cells A2:W10 with data. Some cells are empty, others not.
In column X I would like to join, row by row, the contents of this range excluding the empty cells. The joined results should be delimited by “/”.
Empty rows should be discarded.
I am aware that this can be achieved with one single formula placed on cell X1 combining byrow, lambda and join functions. Is that correct?
Thanks so much.
>Solution :
To omit empty rows try this formula
=QUERY(BYROW(A2:W10, LAMBDA(tj,(TEXTJOIN("/",1,tj)))),
"where Col1 is not null")