Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.

How to combine values into a single cell using TEXTJOIN () in Excel Microsoft 365, Excel 2019 and Excel for the web support the function, TEXTJOIN ().

Check each column individually, and put a 1 or a 0 in a cell below each column. Then test that row of values for a 1. Not pretty, but functional.