Display Column Header(s) if row volume is a 1

[surkdidat]

In my spreadsheet I have column headers in cells AD to AM, starting on row 3.

In the cells below, it has either a 0 or 1 value. Each row can have 1 or more matching column headers.

What I would like to appear in column AN is the names of ANY column that has a 1 value in the row

AD - Cat	AE - Dog	AF - Horse	AH - Chicken	AN (Answer Column)
0	0	1	0	Horse
1	1	0	0	Cat Dog
0	1	1	0	Dog Horse
1	1	1	1	Cat Dog Horse Chicken
0	0	0	1	Chicken
1	1	1	0	Cat Dog Horse

 

[Fluff]

How about

Fluff.xlsm
	AD	AE	AF	AG	AH	AI
1	Cat	Dog	Horse		Chicken	AN (Answer Column)
2	0	0	1		0	Horse
3	1	1	0		0	Cat, Dog
4	0	1	1		0	Dog, Horse
5	1	1	1		1	Cat, Dog, Horse, Chicken
6	0	0	0		1	Chicken
7	1	1	1		0	Cat, Dog, Horse
Sheet6

Cell Formulas
Range	Formula
AI2:AI7	AI2	=TEXTJOIN(", ",,FILTER($AD$1:$AH$1,AD2:AH2=1))

 

[Snakehips]

@surkdidat Try like below.

TestTime.xlsm
	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN
3	Cat	Dog	Horse	Header4	Chicken	Header6	Header7	Header8	Header9	Header10
4	0	0	1	0	0	0	0	0	0	0	Horse
5	1	1	0	0	0	0	0	0	0	0	Cat Dog
6	0	1	1	0	0	0	0	0	0	0	Dog Horse
7	1	1	1	0	1	0	0	0	0	0	Cat Dog Horse Chicken
8	0	0	0	0	0	0	0	0	0	0
9
Sheet2

Cell Formulas
Range	Formula
AN4:AN9	AN4	=IFERROR(CONCAT(FILTER(AD$3:AM$3,AD4:AM4=1,)&" "),"")

HTH

 

[MicCh]

=textjoin(" ",true,rept(ad$3:am$3,ad4:am4))

 

[Cubist]

One more option:

=TEXTJOIN(" ",,IF(AD4:AM4,AD$3:AM$3,""))

 

[surkdidat]

Thanks everyone for your help

 

[Fluff]

Glad we could help & thanks for the feedback.