Return column header

[2wheelz4me]

I am needing to filter by a given company and only return header rows if there is a value "x" in that column. So for my example: I want to filter by company a and see product 3, or company b and see product 1 and product 2, company c would be product 4, etc. I would like to do this via a pivot table or other simple method. Any help would be greatly appricated!! I'm in a crunch so hoping someone can assist. Thanks so much!!!

Account Product 1 Product 2 Prodcut 3 Product 4
Company a x
Company b x x
Company c x
Company d x

[2wheelz4me]

My example did not show up correctly, hopefully this picture will go through.
spreadsheet.jpg

[2wheelz4me]

Anyone have a suggestion?

[AlKey]

For this example enter array formula in G2 and pull it to the right to column J and then down

=IFERROR(INDEX($B$1:$E$1,SMALL(IF($B2:$E2="x",COLUMN($B2:$E2)-1),COLUMNS($A:A))),"")


***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER

Row\Col	A	B	C	D	E	F	G	H	I	J
1	Account	Product 1	Product 2	Product 3	Product 4		Results
2	Company a			x			Product 3
3	Company b	x	x				Product 1	Product 2
4	Company c				x		Product 4
5	Company d	x					Product 1

[2wheelz4me]

Thanks so much!!

[AlKey]

You're welcome and thank you for the feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).

[2wheelz4me]

Solved thanks everyone!!