Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
64
Views
Topic starter
I have a scenario - a list of employees and each of them have to do 3 mandatory courses. I'm attaching a file that has a list of names Is there a way in PQ that would generate an output where each employee would have a row for each course. I have a list of the employees and a list of the courses. I have tried Append/merge/various types of unpivoting.
This is a trial run for something so if there's a better way to do it than what I have..thanks.
Posted : 04/07/2018 8:04 am
You don't need to make complicate things.
Assuming that you load employees table in a query named Table1, and the list of courses is in a query named Table2.
How about adding a new column in Table1 with this formula:
=Table2
Expand the new column and that's all.
Posted : 05/07/2018 11:41 am
