I have tried 3 way to remove
1 using code yourdatatable = yourdatatable.Select("[yourcolumnname] <> ‘’ ").CopyToDatatable() to remove row with empty cell value and
2 Filter datatable to remove row with column name = “”
3 Filter datatable column name is empty.
All end up the same result.
I have no idea why duplicate will happen, i have done the same in another file which is working fine without duplicate row. The amount of duplicate rows is equal to the number of rows that have deleted.