Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Is there a way in Google Sheets to join cells in a range using Byrow, Lambda and Join?

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

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

=QUERY(BYROW(A2:W10, LAMBDA(tj,(TEXTJOIN("/",1,tj)))),
         "where Col1 is not null")
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading