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 ...
Hi,
Please create another tab in the same Excel file and show the expected result on that tab.
I added a sheet, as requested. Below is a screenshot. I want to be able to see the courses taken, the ones that were not taken and if those are even offered, per person.
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.
