Merge 2 datasets with different structure

[selsset97]

Hi, I am trying to merge 2 datasets with the same categories, but different sub-categories into one with all sub-categories.

Here I attach sanitized examples of the datasets I would like to merge, and the desired output:

Dataset to merge 1 (2019)	Dataset to merge 2 (2020)

Desired output (2019, 2020)

As you can see:

• Some lines contained in Dataset 2 do not exist in Dataset 1
  • For example: 107 Company Z
• All categories and sub-categories are contained in the same column.

Thank you in advance! :)

[gabrielvilella]

Hi @selsset97, here is one way of doing this.

[grazitti_sapna]

Hi @selsset97 , another way of getting your output.

[selsset97]

Thank you so much! :)

[selsset97]

Thank you so much!