Formula to return Header if cell content is 1

Would a presentation as follows work for you?

v	A	B	C	D	E	F	G	H	I	J	K
1	Attribute	A	B	C	D	E	F	G	H	I	J
2	Event1
3	Event12	1							1		1
4	Event2	1							1	1	1
5	Event23		1	1		1				1
6	Event3					1		1
7	Event34								1		1
8	favor1								1	1
9	favor2	1	1			1		1	1		1
10	free1						1		1
11	free2					1					1
12	promotion1			1	1					1
13	promotion2					1			1		1
14	promotion3			1	1		1		1	1

Since my post #2 is satisfactory for you, here is how using Power Query. Here is the Mcode and the file attached for your review and analysis

Please Login or Register  to view this content.

Load the table into Power Query. Highlight column A and unpivot all other columns. Pivot the columns using Column 1 as your headers and do not aggregate. Next highlight all columns and use the replace function to replace all zeros with nulls. Close and Load to your excel wb.