Forum Discussion
Solved
Combine two data tables
Hi all, I have 2 data tables - one for store information and another for product info. In short, I need to create a new table that splits out each store showing every product. I need this in orde...
You're looking to do the cartesian product of two tables.
You can use cross join in power query and you'll get your expected result.
You're looking to do the cartesian product of two tables.
You can use cross join in power query and you'll get your expected result.
Amazing, thank you!