- GENERATE NON REPEATING COMBINATIONS IN KUTOOLS EXCEL FULL
- GENERATE NON REPEATING COMBINATIONS IN KUTOOLS EXCEL PLUS
- GENERATE NON REPEATING COMBINATIONS IN KUTOOLS EXCEL DOWNLOAD
GENERATE NON REPEATING COMBINATIONS IN KUTOOLS EXCEL FULL
Set the Join Kind to be Full Outer (all rows from both) Select two separate lists in each section.Ĭlick the Temp column (or whatever name you chose) in both lists.
Our preparation is complete, so we can move on to merging the queries. Make sure the Custom Column name and Custom Column formula are identical across all the queries. But in this example, I’ve used these values. The Custom Name and Column Formula can be any value you wish.
GENERATE NON REPEATING COMBINATIONS IN KUTOOLS EXCEL PLUS
Then you’ll be able to work along with examples and see the solution in action, plus the file will be useful for future reference.ĭownload the file: 0049 List all possible combinations.zip
GENERATE NON REPEATING COMBINATIONS IN KUTOOLS EXCEL DOWNLOAD
I recommend you download the example file for this post. They each teach us different things about Power Query, so it’s worth working through both and understanding the differences. In this post, there are two solutions presented. Let’s dig into Power Query to see how we can solve this problem. We’ll need to get a little more involved. Sounds simple, right? There must be a single function in Excel or Power Query that will generate that… right?Įr, actually… No. The question might come in a simple form, such as: “How can we get a complete list of all General Ledger and Cost Centre combinations?”. Imagine a scenario where you have two or more lists in Excel and want to create a single table of all possible combinations.