Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
231
Views
Topic starter
Hi,
I have two lists in PQ (both formatted as tables), one of dates and one of our production plant codes.
Is there a way of combining these to create a table with a row for each combination of date and plant code.
i.e. My dates are for a year (thus there are 365 of them), we have approx 150 plant codes, thus the end resulting table should have 54,750 rows
Thanks, Lee
Posted : 30/10/2019 10:41 am
Hi Lee,
In one of the tables, simply add a new column with this formula that refers to the other table:
=Table2QueryName
The new column will contain the same table in all rows. All you have to do now is to expand this new column into rows. (you should see this option in advanced options)
Posted : 30/10/2019 2:25 pm
Topic starter
Thanks, that's perfect, I knew it would be something straight forward!
Posted : 31/10/2019 4:31 am
