Forum Discussion
Solved
Merging 2 tables with complementing data
Hi. I have an Excel file with 2 sheets: 1) List of people and the courses they have taken, as well as the department they belong to in our company; 2) List of departments and the courses available ...
Thank you very much. Unfortunately, and I should have made it clear, each person is part of a specific department. The way you went about it made each person appear in more than one department.
You are welcome. You should now be able to apply some filter to get to your end result. If not, then post back with may be a smaller dataset and your exact expected result.