I am attaching the test data. The first tab is the input data. The output tab has a sample of what i am looking for. Basically, the workflow should be able to give me all the possible permutations and combinations of all the five fields.
From what I have seen (including the combination monster macro) - only one column is used as an input. In my test data, there are multiple columns and could have same value across multiple but should be considered different as it is under a different column. For example, M1 can be under UKEM and USEM. Anyone been through something fun like this before and can help me out?
Solved! Go to Solution.
I resolved it actually by modifying the workflow that @ashissanpui gave here Ashihssanpui's Solution. There might be much easier/better way but this works for me for now :). I split each column into its own text input