How to create a table with two new columns based on the two tables of values in Power Query

[Anonymous]

I have one table with one column called stores:

Stores

A

B

C

And I have another table called channels:

Channels

1

2

3

I need to create a new table with two columns "Stores" and "Channels" like this in Power Query

Stores      Channels

A              1

A              2

A              3

B              1

B              2

B              3

C              1

C              2

C              3

For each store, there will be 3 channels. 

Is there any way to achieve this in Power Query? Thank you!

[NishPatel · Accepted solution]

Import both tables into the Power Query. Select Stores table and add Custom Column Channels and Enter formula = #"Channels"[Channels]. Expand the Channels column by selecting Expand to New Rows. And you will achive what you need as below.

[Anonymous]

Thank you very much. It works!

[HotChilli]

https://learn.microsoft.com/en-us/power-query/add-custom-column 

Have a read of this then try my suggestion.

Work your way through it and I will help if you have specific problems

[Anonymous]

Thank you! I don't quite get what you meant. Would it be possible to add a few more detailed steps like screenshots etc? 

[HotChilli]

Add a custom column to table1 with the name of the other table and column , for example, 

Table2[theColumn]

then expand to new rows