Is it possible to merge multiple imported excels with the common attributes?

I am currently doing a small project that requires data visualization while data are stored in different Excel files. For example, entity 1 has attributes “A, B, C, D, E” with 20 records, then entity 2 has attributes “C, F, G, H, J” with 30 records while entity 3 has “H, K, L, M, N” with 50 records. So entities 1 and 2 have the common attribute C, then entities 2 and 3 have the common attribute H, but entities 1 and 3 do not have the common attribute. Is it possible to merge these three entities into one with all the records with the corresponding common attributes?
0 answers