Full Answer
How do you draw possible combinations in a table?
Mar 13, 2019 · Do you want to create a table that shows all available combinations from two list? Say the first list has Items 1,2,3 and the second list has Colors Red, Ora...
What is a combination table?
Draw one column in the top and bottom right quadrants for each combination. For example, if there are two conditions and the first condition has two possible values while the second has three possible values, draw six (2 * 3) columns. 5) Enter all possible combinations of values in the columns in the top right quadrant of the table.
How to create combinations in Excel?
Nov 16, 2017 · Re: Simple List of Combinations From Single Row Table Thank you so much sir, I was searching solution for the same type of combination for last few days, searched everywhere but no result but now i hv solution because of you.
How to list all possible combinations based on multiple columns data?
Feb 08, 2007 · Sub FruitSnackCombos() 'list all combinations of fruit and snacks, starting in cell defined as "TableStartingCell" 'Warning: clear all cells below TableStartingCell or face the program's consequences :( Dim fruitnames, snacknames 'as is, so valid as variants for Array function Dim i As Long, j As Long, iOffset As Long fruitnames = Array("apple", _ "pear", "peach") …
Power Query solution
L et’s assume you have three state codes and four department codes and you want to create a table of all the possible 12 combinations (3 x 4). How do you do it so that it is flexible? i.e. if you add a new state or department it must be easy to update the combination table.
Post navigation
Please note: I reserve the right to delete comments that are offensive or off-topic.
Why do you use table combinations?
Table combinations allow you to leverage the true flexibility of your floor plans. By setting up table combinations, you have the opportunity to snag more reservations than you normally would, as they allow for more flexibility when diners search for availability.
How to combine tables in OpenTable?
Log into the OpenTable Website. Click on the Menu tab in the upper left corner, and then click on Availability Planning. Select the Table Combinations tab, and then choose the Dining Area and the Table Type that you'd like to add combinations for. Please Note: Tables that are different table types cannot be combined together.
How to edit a combo in Word?
To edit a combination's min / max size, locate the combo and click on the combination in the list, then edit the text field boxes. To delete a combination just click on the combo and then click on the Trash icon to the right of the combo.
Why use a decision table?
Decision Tables are an excellent tool for both testing and requirements. It is a structured way to formulate requirements and test cases when dealing with complex business rules. Using a decision table will make it easier to write requirements that cover all alternative conditions in business rules. When writing test cases the table will help you ...
What does each column in a decision table represent?
This means that each column represents a test case. Decision tables are excellent tools to use for requirements management or testing as they make it easy to see when certain ...
How many quadrants are there in a decision table?
A Decision Table is usually divided into four quadrants as in the table below. The upper half of the table lists the conditions being tested while the lower half lists the possible actions to be taken. Each column represents a certain type of condition or rule.
Why are decision tables important?
Decision tables are excellent tools to use for requirements management or testing as they make it easy to see when certain pathways have been missed. This then helps testers to write better, more detailed test cases. They are also a great way of tracking the outputs of various combinations.
What does Company X sell?
Company X sells merchandise to wholesale and retail outlets. Wholesale customers receive a two percent discount on all orders. The company also encourages both wholesale and retail customers to pay cash on delivery by offering a two percent discount for this method of payment. Another two percent discount is given on orders of 50 or more units. Each column represents a certain type of order.
Create a Connection Only Query for the Two Lists
For each table, we’re going to create a connection only query that adds a column with the same constant value in each row. We will then use this column to join our two tables together using a merge query.
Join the Two Connection Only Queries with a Merge Query
Now we are ready to join these two lists together using a Merge query.
Our List of All Possible Combinations
Now we have a table which contains every possible combination of items from List1 and List2.
A Slightly Quicker Method
Since writing this post, I’ve found a slightly quicker method to do this. In this method, we still need to load both tables into power query, but we will only need to create one custom column and we don’t need to create a merge query.
About the Author
John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.