Split a DataTable into two based on a column group

Help Something Else
7

Please assign the following code to two different tables as follow

DT1 = dt.AsEnumerable.Take(dt.AsEnumerable.toList.FindLastIndex(function(row) row(“Category”).ToString.Equals(“BBB”))+1).CopyToDataTable

DT2 = dt.AsEnumerable.Skip(dt.AsEnumerable.toList.FindLastIndex(function(row) row(“Category”).ToString.Equals(“BBB”))+1).CopyToDataTable