Hello there,
Maybe you can help me with this question! I would appreciate it!
Okay, so the problem is I have a table with some data in it (just ones) and I want a column that gives me that data but compromised. I would like to have a string with just the headers of those column in which the one is.
I looks like this:
I am sure I can bind the string together with =Textjoin but I am not really sure how to extract those headers. Especially if I have more than one header.
I hope you can help me.
Greetings,
Manú
Maybe you can help me with this question! I would appreciate it!
Okay, so the problem is I have a table with some data in it (just ones) and I want a column that gives me that data but compromised. I would like to have a string with just the headers of those column in which the one is.
I looks like this:
COLUMN I WANT TO HAVE | header1 | header2 | header3 | header4 | |
indicator1 | header1 | 1 | |||
indicator2 | header4 | 1 | |||
indicator3 | header2 | 1 | |||
indicator4 | header1,header3 | 1 | 1 |
I am sure I can bind the string together with =Textjoin but I am not really sure how to extract those headers. Especially if I have more than one header.
I hope you can help me.
Greetings,
Manú