Can someone please help with providing a formula which generates a list of text values in multiple columns which satisfy a certain criteria (i.e. a '1' in the row) and ignores the blank cells.
Example below:
<tbody>
NAME1
NAME2
NAME3
NAME4
NAME5
NAME6
NAME7
NAME8
NAME9
NAME10
1
1
1
1...