VLOOKUP? If cell has a "1", then return column header

I am looking to find a way to perhaps do a VLOOKUP to pull back the column headers when cells contain a value of "1". Pretty much go from this:

Customer Apple Banana Pear Peach
A1122 1 1 1
A2231 1 1
A3011 1 1 1
A4122 1 1 1 1

To this:

Customer Prod1 Prod2 Prod3 Prod4
A1122 Apple Banana Pear
A2231 Banana Peach
A3011 Apple Pear Peach
A4122 Apple Banana Pear Peach

Can anyone help, please? I am new to this forum and a novice to excel, so any assistance would be greatly appreciated. Thanks!

Hi Mattbr80,

You can use the following formula:-
{=IFERROR(OFFSET($A$1,0,SMALL(IF($B2:$E2=1,COLUMN($B2:$E2),""),COLUMN(A$1))-1),"")}

See the attached :-

Customer Sample Report.xlsx
Regards,
DILIPandey

<click on below 'star' if this helps>