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.

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

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.

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

Hi,

You may download my solution file from here.

Hope this helps.

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

    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.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      4 years ago

      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.