Hi there, I have three data tables as attached. I do not know how to set the activities to produce the desired result as attached.
The steps required:
-
If you open DT3, you can see there are only partner numbers without corresponding partner names. The Corresponding names could be found in DT2. I need to look up the names in short form (I.e. Lookup value is Partner Code; it should return corresponding partner names in short form to DT3)
-
Then, if you open DT1, you can see the BankNo in Column C. The BankNo is also in DT3. However, there could be more than one BankNo in DT3 referring to only one row in DT1. What I need to do is - for all partner names and corresponding percentage with the same BankNo in DT3, write to the row in DT1 in which the BankNo matches, and using semicolons to separate the partners. Please see the desired result file for your reference.
How can do it? Much appreciate your help!!!
DT1.xlsx (63.4 KB)
DT2.xlsx (10.5 KB)
DT3.xlsx (9.5 KB)
DT Desired Result.xlsx (63.6 KB)