Table 1
ABC
BCD
DEF
NDH
FRD
TRY
ENT

Table 2 Value
ABC 1
DEF 3
NDH 5

Table 3 Value
ABC 2
BCD 3
FRD 5
TRY 6

Table 4 Value
NDH 2
ENT 5
ABC 3

I want to pull up values for list in table 1 from table 2,3,4

I tried merging (1&2, 1&3, 1&4) uniques then appending all/ Appending all then merging with Table 1 but it gives duplicates. when i remove duplicates it using table 1 identifiers it removes few values like in ABC when all are appended it looks like

ABC 1
ABC 2
ABC 3

But i want something like one the same line
Value 1 Value 2 Value 3
ABC 1 2 3

Am unable to achieve this. Please help.