Forum Discussion

karimk's avatar
karimk
Icon for Helper III rankHelper III
4 years ago
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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my solution file from here.

    Hope this helps.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

karimk , Create a column department - course in both table and join then to analyze

 

key = [department] & "-" & [course]

karimk's avatar
karimk
Icon for Helper III rankHelper III
4 years ago

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.