I want to remove duplicate rows by comparing the rows of the same column. If the content of row1 is ma to row 2 then delete row1 and so on till the end of selected rows.
The code “DataTable distinctTable = dtRows.DefaultView.ToTable(true, “column1”);” will give me distinct values but I want to remove only the row which are cosecutive and keep 1 row.
I have a list of program to be broadcast in a day. A program will have repeat telecast also. So i want to remove the program name if they appear twice or trice consecutive only.
I hope this time I am much clear with the problem statement.