Excel Table extracting headers

[ManuW]

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:

	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ú

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F
1		COLUMN I WANT TO HAVE	header1	header2	header3	header4
2	indicator1	header1	1
3	indicator2	header4				1
4	indicator3	header2		1
5	indicator4	header1,header3	1		1
Master

Cell Formulas
Range	Formula
B2:B5	B2	=TEXTJOIN(",",,IF(C2:F2=1,$C$1:$F$1,""))