I want to return the column headings for each x in a record (row) I can find the first using index and match but not subsequent column headings.
<tbody>
</tbody>
here i need to display header value(edu,chat,...)where ever x value is there and display header value in another column
how to write the formula
ad | ae | af | ag | |
1 | edu | chat | human | footprint |
2 | x | x | ||
3 | x | |||
4 | x |
<tbody>
</tbody>
here i need to display header value(edu,chat,...)where ever x value is there and display header value in another column
how to write the formula