I want a method to achieve this

[P-A-J (P)]

I am getting the output as
Result.xlsx (9.0 KB)

[Yoichi]

Hi,

Did you run the above sample as it is? In my environment output is as the following.

Regards,

[Zidan_Mohamed]

The answer @Nguyen_Van_Luong1 will work.
Just need to sort the datatable by ID by using ‘Sort Data Table’ Activity or by using linq: datatable.Select().OrderBy(function(row) row(“id”)) and then iterate through each row using for each data row activity and assigning current id to a variable on each loop which is used compare with the next id. If the id is repetitive, just assign string.empty or nothing to id column while adding the data row to a data table you build using build data table activity.

You can try and let me know👍
Regards

[Zidan_Mohamed]

Also add the copytodatatable at the end to convert it to data table:
datatable.Select().OrderBy(function(row) row(“id”)).CopyToDataTable

Regards