Built Formula for Comma-Separated String For Values Equal to "Yes"

[Joe4]

I have a grid of data that can contain one of three entries: Yes, No, and nothing (empty string).
I need to build a string for each row of values that will return a string of the headers, separated by commas, but only for the columns with "Yes" in them.

So in the image below, the black is my data grid, and the red is my desired result for each row of that grid:

I was trying to do it with TEXTJOIN, but it is a little more complicated than that. I could do it rather easily myself with VBA, but am looking for a formulaic solution.

Can anyone assist?

 

[JEC]

Try

=TEXTJOIN(",",,IF(A2:C2="Yes",$A$1:$C$1,""))

 

[Joe4]

Wow, I thought I was overlooking something obvious, and I was right! That was easier than I thought!
Thanks!

 

[JEC]

Np! All in one go

=BYROW(IF(A2:C4="Yes",A1:C1,""),LAMBDA(a,TEXTJOIN(",",,a)))

 

[Joe4]

I was going to have a follow-up question, what if the headers in row 1 weren't exactly what you needed in the returned string, how could I tell it which ones to return.
But it was a relatively easy edit to the original formula you posted, i.e.

=TEXTJOIN(",",,IF(A2:C2="Yes",{"PHI","PII","PCI"},""))

or to your updated formula:

=BYROW(IF(A2:C10="Yes",{"PHI","PII","PCI"},""),LAMBDA(a,TEXTJOIN(",",,a)))