How to remove duplicates from Datatable and count how many times it appears


I’m looking for the best approach to remove duplicates from my datatable( I have just one column), but I also need to count how many duplicates I have there( for example this id:1234 occurred 3 times).

I would be grateful for some tips, thanks

@Mateusz_Koper u can use use like below for removing duplicates, since ur saying single column.


where dt is the datatable name

@Mateusz_Koper Follow below link’