Get Column Header if Condition is Met
 

Hi

I have data like this.

AA BB CC DD
Data 1 1 0 0 0
Data 2 0 0 1 0
Data 3 0 0 1 0
Data 4 1 0 0 0

I want to build a New Summarized Table that looks like


DAta 1 AA
Data 2 CC
Data 3 CC
Data 4 AA

Thanks for your help.

Prasad