Split a DataTable into two based on a column group

Help Something Else
4

As I specified, I need to split the Data Table but I also want to avoid having the same category in the both Data Tables.

Example :
The image shows a table with columns labeled "Category", "Column B", and "Column C", containing repeated categories and corresponding data entries. (Captioned by AI)
I have 9 rows so the first data table should contain 5 rows and the second should contain 4, but I don’t want to have the “BBB” category within the both data tables, I need to get all the rows until the category changes; so there should be 6 rows for the first data table and 3 rows for the secon one.