Pivot Table Count Combinations Binary Numbers

Hi Forum,

I have a list of defects (Y/N) converted into (1,0); I want to find all possible combinations (no repeat/no order). In this case there are 7 possible (n) defects; 28 different combinations (I have not listed them on my spreadsheet).

Is there an easy way to use excel (possibly using pivot table) in the count and chart combinations of these:

1,0,0,0,0,0,0 =
0,1,0,0,0,0,0 =
0,0,1,0,0,0,0 =
0,0,0,1,0,0,0 =
0,0,0,0,1,0,0 =
0,0,0,0,0,1,0 =
0,0,0,0,0,0,1 =
...............

See attached excel sheet.

Thanks BO!