Split a DataTable into two based on a column group

Help Something Else
3

Hi @SONYC

Can you try like below

The image shows a flowchart with steps to read an Excel worksheet, group data by a specific column, and write the grouped data back to the workbook. (Captioned by AI)
The image shows a flowchart with steps to read an Excel worksheet, group data by a specific column, and write the grouped data back to the workbook. (Captioned by AI)818×610 30.9 KB

dt.AsEnumerable.GroupBy(Function (x) x("Category").ToString).Select(Function (x) x.CopyToDataTable).ToList

currentDataTable.Rows(0)("Category").ToString

Regards,