Return column headers for all true values Google Sheets

[TimK34]

Hi everyone,

I have a large data sheet with a list of suppliers and one column for each supplier with a TRUE or FALSE value.
I'd like to consolidate all true suppliers in one cell.

In the image below I'd like column G to summarise all suppliers with the value TRUE (i.e. "Supplier 2, Supplier 3" for row 3.

Can anyone help me with the right formula?

Many thanks

Tim

 

[Fluff]

Hi & welcome to MrExcel.
How about

=TEXTJOIN(", ",,IF(B2:F2,$B$1:$F$1,""))

 

[ClaireS]

Book1
	A	B	C	D	E	F	G
1	Company	Supplier 1	Supplier 2	Supplier 3	Supplier 4	Supplier 5	Suppliers
2	Company A	FALSE	TRUE	FALSE	FALSE	FALSE	Supplier 2
3	Company B	FALSE	TRUE	TRUE	FALSE	FALSE	Supplier 2, Supplier 3
4	Company C	FALSE	TRUE	FALSE	FALSE	TRUE	Supplier 2, Supplier 5
Sheet1

Cell Formulas
Range	Formula
G2:G4	G2	=TEXTJOIN(", ",TRUE,IF(B2:F2,B$1:F$1,""))

 

[TimK34]

Amazing!!! Thank you so much both of you. I'm so grateful

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[TimK34]

Amazing!!! Thank you so much both of you. I'm so grateful

I jumped the gun too quickly. I've tried both and seem to get this error "Error - An array value could not be found". I'm using Google Sheets, but this should support the formula? Any ideas? Thanks @ClaireS @Fluff

 

[Fluff]

If you need something for Sheets you should clearly state that, you should also post the question in the General Discussion & Other Applications section.
I have moved it for you this time.

Not all Excel formulae & functions work in Sheets.

 

[Fluff]

Not sure if this will work in sheets, but try

=TEXTJOIN(", ",,filter(B$1:F$1,B2:F2))

 

[TimK34]

Tested it before ticking the box this time. It worked like a treat. Thanks so much @Fluff

 

[Fluff]

You're welcome & thanks for the feedback.