Generate All Possible Combinations in Excel

Generate all possible combinations of multiple lists in Excel. This technique can be useful in a variety of contexts, such as analyzing how many possible substitute or complementary products are available near your stores or exploring all possible outcomes for a given scenario.