Hi,
I have few columns in which either there is Yes or no as values. I need a formula to return all column headers where there is yes separated by comma. I have more than 50000 records and have to do this on every other day. Is there a way to achieve this through a formula? Here is an example:-
<tbody>
</tbody>
Thanks in advance
I have few columns in which either there is Yes or no as values. I need a formula to return all column headers where there is yes separated by comma. I have more than 50000 records and have to do this on every other day. Is there a way to achieve this through a formula? Here is an example:-
Required result | Header 1 | Header 2 | Header 3 | Header 4 | Header 5 |
Header 1, Header 3, Header 4 | Y | N | Y | Y | N |
Header 2, Header 4, Header 5 | N | Y | N | Y | Y |
<tbody>
</tbody>
Thanks in advance