return column header for exam

[rawdata89]

Hello

I am trying to create the exams taken column with a very large file. What would I need to use to create something like column b (EXAMS TAKEN) where it returns the coulmn header by student who took a given exam?

Student No.	EXAMS TAKEN	ART EXAM	PE EXAM	FREE LUNCH?	MATH EXAM	SPECIAL ED?
Student 1	PE EXAM & MATH EXAM	FALSE	98	TRUE	90	TRUE
Student 2	PE EXAM	FALSE	100	TRUE	FALSE	FALSE
Student 3	ART EXAM & PE EXAM & MATH EXAM	89	95	FALSE	75	FALSE

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C	D	E	F	G
1	Student No.	EXAMS TAKEN	ART EXAM	PE EXAM	FREE LUNCH?	MATH EXAM	SPECIAL ED?
2	Student 1	PE EXAM & MATH EXAM	FALSE	98	TRUE	90	TRUE
3	Student 2	PE EXAM	FALSE	100	TRUE	FALSE	FALSE
4	Student 3	ART EXAM & PE EXAM & MATH EXAM	89	95	FALSE	75	FALSE
Data

Cell Formulas
Range	Formula
B2:B4	B2	=TEXTJOIN(" & ",,FILTER($C$1:$G$1,(C2:G2<>FALSE)*(ISNUMBER(SEARCH("exam",$C$1:$G$1)))))

 

[rawdata89]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C	D	E	F	G
1	Student No.	EXAMS TAKEN	ART EXAM	PE EXAM	FREE LUNCH?	MATH EXAM	SPECIAL ED?
2	Student 1	PE EXAM & MATH EXAM	FALSE	98	TRUE	90	TRUE
3	Student 2	PE EXAM	FALSE	100	TRUE	FALSE	FALSE
4	Student 3	ART EXAM & PE EXAM & MATH EXAM	89	95	FALSE	75	FALSE
Data

Cell Formulas
Range	Formula
B2:B4	B2	=TEXTJOIN(" & ",,FILTER($C$1:$G$1,(C2:G2<>FALSE)*(ISNUMBER(SEARCH("exam",$C$1:$G$1)))))

You saved me so much time, it works beautifully, thank you so much!!!!!!

 

[Fluff]

You're welcome & thanks for the feedback.