I'm trying to merge two tables together. One is a customer list and another is a product list. I want to combine the two and expand the customer list with the product list. How would I do this in power query.
Customer List
<tbody>
</tbody>
Product List
<tbody>
</tbody>
Result
<tbody>
</tbody>
Customer List
Customer | Product List |
Customer1 | Food |
Customer 2 | Consumer |
<tbody>
</tbody>
Product List
Product List | Product | |
<tbody> </tbody> | Product 1 | |
<tbody> </tbody> | Product 2 | |
<tbody> </tbody> | Product 3 | |
<tbody> </tbody> | Product 4 | |
<tbody> </tbody> | Product 5 | |
<tbody> </tbody> | Product 6 |
<tbody>
</tbody>
Result
Customer | Product List | Product |
Customer1 | Food | Product 1 |
Customer1 | Food | Product 2 |
Customer 2 | Consumer | Product 3 |
Customer 2 | Consumer | Product 4 |
Customer 2 | Consumer | Product 5 |
Customer 2 | Consumer | Product 6 |
<tbody>
</tbody>