Delete duplicate rows after adding content to original row

Hello Everyone;

I have a datatable dt, which has 2 columns (number(int), value(string)), there are rows with the same number, but different values, i want to first concatenate the values to 1 row, then delete the duplicate rows.

anyone knows an efficient way to do that?


Can you send a sample excel file??..

unfortunately it’s a part of a large workflow, so it’s pretty complicated…

Just type ,a sample input file and output file you wanted in below reply. @Ahmed_AbdelRahman