Automatic assign team members to projects|Power Query|Excel Forum|My Online Training Hub

Hi,

I would appreciate it if some one can help me with my excel question below.

I have 3 tables:
1. Table 1 contains staff names (350 members), names of team/squad each staff belongs to (about 10 teams), and their monthly rate => This list keeps getting updated due to leavers and new staff joining in.
2. Table 2 contains a list of 10 projects.
3. Table 3 shows which team spend how much time on which project(s) in each month of the year => This table keeps changing based on the changing business priorities

The table looks like this - January 2023, Team 1 - 30% Project 1, 30% on Project 2 and 40% on Project 3.
Team 2 is assigned to spend 50% of their time on Project 5 and 50% on Project 7
Team 3 is assigned to spend 70% of their time on Project 6, 20% on Project 8 and 10% on Project 10, etc.

My task is to show:

1. Each month, who is working on which project
2. The monthly costs of each project

I am wondering if there is a quick way to create a 5 column table that lists down which staff is working on which project based on data from Table 1 and Table 3 above.

For example:
Staff A - Team 1 - 30% - Project 1 - January 2023
Staff A - Team 1 - 30% - Project 2 - January 2023
Staff A - Team 1 - 40% - Project 3 - January 2023

Many thanks for your help.