I have been stuck on this for a day now, it seems so simple but I am struggling to find the solution. I am looking to create all possible scenarios based upon two options.
Example 1
My Data
| Option 1 | Option 2 |
| Apple | On |
| Orange | Off |
Desired Outcome
| Scenario | Option 1 | Option 2 |
| 1 | Apple | On |
| 1 | Orange | On |
| 2 | Apple | On |
| 2 | Orange | Off |
| 3 | Apple | Off |
| 3 | Orange | On |
| 4 | Apple | Off |
| 4 | Orange | Off |
Example 2
My Data
| Option 1 | Option 2 |
| Apple | On |
| Orange | Off |
| Cherry | |
Desired Outcome
| Scenario | Option 1 | Option 2 |
| 1 | Apple | On |
| 1 | Orange | On |
| 1 | Cherry | On |
| 2 | Apple | On |
| 2 | Orange | On |
| 2 | Cherry | Off |
| 3 | Apple | On |
| 3 | Orange | Off |
| 3 | Cherry | On |
| 4 | Apple | On |
| 4 | Orange | Off |
| 4 | Cherry | Off |
| 5 | Apple | Off |
| 5 | Orange | On |
| 5 | Cherry | On |
| 6 | Apple | Off |
| 6 | Orange | On |
| 6 | Cherry | Off |
| 7 | Apple | Off |
| 7 | Orange | Off |
| 7 | Cherry | On |
| 8 | Apple | Off |
| 8 | Orange | Off |
| 8 | Cherry | Off |
