JOIN only if cell is not blank
Is there a way I can use the JOIN function to merge the contents of an entire row from another sheet, but exclude rows that are blank?
The contents of the other sheet is generated from a form (and being constantly updated), so referencing the entire column is the only option unfortunately.
It seems like it should be easy, but I am drawing a blank on how to do it.
Help Article Resources
Check out the Formula Handbook template!