Delete duplicate rows after adding content to original row

Help Studio
, , ,
1

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?

Thanks

2

Can you send a sample excel file??..

3

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

4

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