HI, I need to check the contents of 29 columns and return the text
values of all the non-zero cells in that row.I am trying to run an if-
then statement to acheive the following:

if (B1:AD1 1, (return the text within the cells as multiple strings
separated by commas),0)
I need help on how to acheive this result. I tried concatenation but
it wasn't working out.

Thanks