I have an excel workbook with approx. 20 columns (CFP, CPA, etc, etc). Most rows are "blank" but occasionally there is a "yes" in a column.
I need a formula or macro to read each column (per row), convert the "yes" to the appropriate column heading, and add a separator (, ) if there is another item in a new "concatenated column).
So, the end result would look like this: CFP, CPA or CFP or CFP, CPA, ChFc
Thanks in advance!!