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 ...
karimk , Create a column department - course in both table and join then to analyze
key = [department] & "-" & [course]
Hi. Not sure if it worked. I added a sheet to show the expected result. 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.
