Segregating an excel file depending on its "Branch" column using LinQ

Help Activities
, ,
2

@Llessur
have a look here for some general concept options:
[HowTo] Overview on different options for grouping data and processing the groups - News / Tutorials - UiPath Community Forum

Linq Approach:

Assign Activity:
TableList | Datatype: List(Of DataTable) =

(From d in YourInputDataTableVar.AsEnumerable
Group d by k=d("Branch").toString.Trim into grp=Group
Select t=grp.CopyToDataTable).toList

Then loop over TableList (e.g For each activity) and write it down to excel