Hello Team:

I have very tricky situation. The data looks as below. If respondent selects the product the data will be captured as 1 and if not it will be 0.

ProductA ProductB ProductC ProductD 0 0 0 1 1 1 1 0 0 0 1 1 1 0 0 0 1 0 0 0

I want an output that produces the count of 1 across product combination. So based on above example, following should be the output:

Combination Count ProductD 1 ProductA,B,C 1 ProductCD 1 ProductA 2

Your inputs are highly appreciated.

Thanks

Manmit