help autopopulate combinations in a table

I have a table which I need to use to determine all possible testcases.

Therefore, I need to determine and specify all unique combinations.

In terms of 1 (set), and 0 (not set),

Does Excel provide a formula to populate all possible rows with unique combinations for all classes?

see attached a file with an example. In the example I have manually populated 2 rows, but there are more (I think in total 64, but not sure).

I was thinking Excel might be able to help me with this, so that all (64 ?) unique rows are populated.

2019-05-10_18-19-21.png

Originally Posted by mgroen

I am looking for a formula which also works for having > 2 choices per class.

Are some of the choices mutually exclusive? In other words for class-1 can you have both "yes" and "no" or is it either "yes" or "no"? If the latter then the number of combinations is substantially reduced. If the former, then in the case of example-2 you now have 8 columns instead of 6 columns so isn't it just an extension of what Martin did in post #3 extended to 8 columns instead of 6 for a total number of 2^8 = 256 combinations or rows?

All,

I have found a tool which calculates all possible values, and its output can be loaded in Excel.

Exactly what I needed, the tool is called Pict , more info on it (google on pict pair wise testing tool
Thanks for all the help!