How to get the count of the duplicate columns from a DT

Welcome to the forum

Prepare an empty DataTable with build datatable and configure the target column structure - dtTarget

dtTarget = dtOrig.Clone + Add Data Column activity and add the Count col at the end

Assign Actvity
dtTarget =

(From d in dtOrig.AsEnumerable
Group d by k1=d("Name").toString.Trim, k2=d("Sports").toString.Trim into grp=Group
Let ra = new Object(){k1,k2, grp.Count}
Select r = dtTarget.Rows.Add(ra)).CopyToDataTable