Forum Discussion
How to create a table with two new columns based on the two tables of values in Power Query
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...
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.
HotChilli
Community Champion
Community Championhttps://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