Dear Team,
I'm struggling to get all possible combinations of each value. I need to create a list of all possible combinations of values for each. Below is an example of the input and the expected output. Any suggestions on how I could solve this?
Input
| C1 | C2 | C3 | C4 | C5 | C6 | C7 |
| Mismatch | OK | OK | OK | OK | OK | OK |
Output
| C1 | C2 | C3 | C4 | C5 | C6 | C7 |
| OK | OK | OK | OK | OK | OK | OK |
| Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | Mismatch |
| Mismatch | OK | OK | OK | OK | OK | OK |
| Mismatch | Mismatch | OK | OK | OK | OK | OK |
| Mismatch | Mismatch | Mismatch | OK | OK | OK | OK |
| Mismatch | Mismatch | Mismatch | Mismatch | OK | OK | OK |
| Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | OK | OK |
| Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | OK |
| Mismatch | Mismatch | OK | OK | OK | OK | OK |
| Mismatch | Mismatch | Mismatch | OK | OK | OK | OK |
| Mismatch | Mismatch | Mismatch | Mismatch | OK | OK | OK |
| Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | OK | OK |
| Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | OK |
| Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | Mismatch | OK |
And go on, till all the possibilities are completed.
Solved! Go to Solution.
Thanks

