Split DataTable based on two unique values

We can do it with help of group by

Assign Activity:
Left side: TableList | DataType: List(Of DataTable)
Right side:

(From d in YourDataTableVar.AsEnumerable
Group d by k1=d(“A”).toString.Trim, k2=d(“B”).toString.Trim into grp=Group
Select t=grp.CopyToDataTable).toList

Afterwards you can iterate with a for each activity and write out the tables to excel

Also have a look here: