Split a DataTable into two based on a column group

Help Something Else
2

@SONYC

you can use

fIRSTtABLE = dt.AsEnumerable.Take(Math.Round(dt.RowCount/2,0)).coPYtOdATATABLE
SecondTable = dt.AsEnumerable.Skip(Math.Round(dt.RowCount/2,0)).coPYtOdATATABLE

Or you can use groupby as well

dt.AsEnumerable.GroupBy(function(x) x("Category").ToString) - this gives groups of datatable can be used inf or each to get each table or get as dictionary as well

cheers