Join text together if condition is met

[keef2]

Hey all,

Have a situation I am stumped on. The overview is I have a long list of employees with appropriate trainings. What I am looking to do is if "x" is in the box I want to join all text for all "x" values. Text values will be in row 3 in this example. I cannot seem to find the right solution, any help is much appreciated.

For this example Javier is where I tried to get something to work unsuccessfully. The output should be "CPR, 30hr, CP, HS, CT, R".

Schedule KEM WORKING.xlsm
	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
3						CP	30hr	10hr	cpr	hs	r	a	ct	st
4	Employee Information					Trainings
5	FOREMAN				Phone #	Competent	OSHA 30	OSHA 10	CPR	Hand Signal	Rigging	Asbestos	Certa Torch	Scaffold
6	Javier Rodriguez		CP			x	x		x	x	x		x
7	Pedro Rodriguez CT,HS,RT,ST,R,30hr
8	Santos Toribio CPR,30hr,CP,HS,CT,R
9	Jose Portillo CP,HS,CT,R
10	Bob Faulkner 30hr,CP,HS,CT,R
11	Marco Barajas 30hr,CP,CT,R
12	James Fredericks 30hr,CPR
Inputs

Cell Formulas
Range	Formula
U6	U6	=TEXTJOIN(" ",TRUE,IFS(X6="x",X3,Y6="x",Y3,Z6="x",Z3,AA6="x",AA3,AB6="x",AB3,AC6="x",AC3,AD6="x",AD3,AE6="x",AE3,AF6="x",AF3))

 

[Fluff]

How about

=TEXTJOIN(" ",,FILTER(X3:AF3,X6:AF6="x"))

 

[keef2]

How about

=TEXTJOIN(" ",,FILTER(X3:AF3,X6:AF6="x"))

Gosh dang works like a charm, I love you Fluff! Always simple yet effective, cheers!

 

[Fluff]

You're welcome & thanks for the feedback.