Excel: Find unique values for same records

[V_Novice]

Hi,

There are three Excel Files:
Reference_Input
ID
123456789
987654321
101234569

Input

ID	Number
101234569	312345678981778
101234569	323456789129641
123456789	334567891273308
123456789	345678912302541
123456789	356789123401032
987654321	367891234501033
987654321	378912345601034
987654321	389123456701035
987654321	391234567801036

Output

Reference Input has values that needs to be checked in Input that has multiple unique values for the same record (ID)-These multiple, unique values have to be stored in the same column in Output separated by comma

Thanks!

[ppr (Peter Preuss)]

@V_Novice
Find some starter help with a reduced and shortened dataset here:
V_Novice_SimulatedGroupBy_ColConcat.xaml (11.2 KB)

For integrating with your code just incorporate the different read range / write range with the Excel files.
Feel free to shift the different Datatable names

Let us know your feedback

[V_Novice]

Thanks a lot for the quick reply. Let me give it a try