Hi, I am trying to split / group data in excel on the basis of a specific row content and storing it in a separate data table.
Sharing the example below:
I am having an excel sheet with column names as “BatchID”, “EmployeeName”, “StartDate” , “EndDate” etc.
“BatchID” unique for one single employee, and there can be multiple entries of one employee.
Likewise there is data for N number of employees in one sheet,
The data is already grouped by assigning specific “BatchID” for each row for single employee.
I want to separate this data as a dataset based on “BatchID” and store in separate datatable.
Below is image of the excel sheet data.
Please help on this.