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
You also might consider using the Subset formula if you wish to see in the same cell the Id and list of all associated Values: [Id]+" "+SUBSET_UNIQUESLIST([Value], SUBSET([Id]))
In case the values in source tables 2,3,4 are merged e.g. "ABC 2" , "BCD 3", you could use Merge block function "Starts with", then use the Expand block before aggregation.