is it not possible can we perform below operation directly on excel instead of building new data table
Newdt = (From d In Dt.AsEnumerable()
Group d By k=d(“Name”).toString.Trim Into grp = Group
Let k1 = String.Join(“,”,grp.Select(function(x) x(“Issue ID”).Tostring).ToArray)
Let ra = New Object(){k,k1}
Select r = Newdt.Rows.Add(ra)).CopyToDataTable()