Assign Activity
TableList | List(Of DataTable) =
dtData.AsEnumerable().GroupBy(Function (x) x("Type").toString.toUpper.Trim).Select(Function (x) x.CopyToDataTable).toList
Then loop over the Table List and write out ech iterated Table to a Worksheet
Worksheetname = LoopedTableVar.Rows(0)(“Type”).toString