Follow these steps.
- Build Result data table like this using Build Datatable activity

2.Use this LINQ in Assign activity
(From row In dtInput.AsEnumerable() Group row By name = row("Name").ToString() Into Group Select dtResult.Rows.Add(name, Group.Count())).CopyToDataTable

Output:
