Thank you for your answer. I think I can to resolve it using dt=dt.DefaultView.ToTable(True) because I’m working with the entire data table.
The problem now is that I have two equal rows that differ only for one space and robot can’t recognize it.
There is a way to remove all spaces from the entire table?
you should not remove all the empty space, you need to remove at the end only
try like this ((From LineNo In dt.DefaultView.ToTable(True,"Product").Select().ToList() Select (From row In dt.Select Where row("Product").ToString.Trim=LineNo("Product").ToString.Trim Select row).ToList(0)).ToList()).CopyToDatatable()