Data table
+----+---------+-------------------+-------------+
| id | title | email | commentname |
+----+---------+-------------------+-------------+
| 3 | test | rob@hotmail.com | rob |
| 4 | i agree | rob@hotmail.com | rob |
| 5 | its ok | rob@hotmail.com | rob |
| 6 | hey | rob@hotmail.com | rob |
| 7 | nice! | simon@hotmail.com | simon |
| 8 | yeah | john@hotmail.com | john |
+----+---------+-------------------+-------------+
expected Dt
+----+-------+-------------------+-------------+
| i email | commentname |
+----+-------+-------------------+-------------+
| simon@hotmail.com | simon |
| john@hotmail.com | john |
+----+-------+-------------------+-------------+
Blockquotedt.AsEnumerable().GroupBy(Function(i) i.Field(Of String)(“ColumnName”)).Select(Function(g) g.First).CopyToDataTable()
issue in this code is it gives one dublicate row can some one modify to remove all duplicates based on commentname coloumn