Hi,
I am trying to find a way to generate all possible combinations from a list. The requirements of this specific task differ from other posts I've read.
1. Each combination should maintain the order of the rows and thus eliminate duplicates caused by switching fields. ex: Column A: Dog Column B: fur = Dog,fur NOT fur,dog
2. This is text based as each column represents a parameter for systems testing and thus each column must be included in each result. => every result should have 8 variables generated.
3. Currently I have 8 columns each with a different number of variables (<5 in each) but i would like to be able to change this in the event we need to add further categories.
Any guidance provided would be greatly appreciated and a huge time saver!
Many Thanks.
Bookmarks