Write out all possible combinations from Excel tables (the cartesian product)

This video shows how to write out all possible combinations from any number of Excel tables - also called the cartesian product. So a table containing "2019", "2020" and "2021" combined with another table with "A", "B" and "C" and a third with "XX" and "YY" fully written out would result in this table:
2019 A XX
2019 A YY
2019 B XX
:
2021 C YY

[@aha1234]

Thanks, It was really helpful.

[@ravibudithi2687]

Hi could you please help me with a similar kind of issue, where I just have a single column having different numeric values and I need to find all the possible combination. Like if the values are 3.5, 4.5, 3, 5.3 etc, the output should be 3.5+4.5=8, 3.5+3=6.5, 3.5+5.3=8.8, 4.5+3=7.5 and so on...

[@leiflauridsen410]

You can use the exact same logic as shown in the video. In this case, create two tables with your list of values in Power Query and then merge into a table with the cartesian product. Then in excel add the formula you desire (or in Power Query add a third column with the formula)

[@mocksterling850]

How can i do this with 1-26

[@leiflauridsen410]

Hi Mock, do you mean a table with the numbers 1-26? If so, simply add a table with those numbers similar to the ones shown. Or what do you mean?