How to group the rows which has similar information

[thima (Himabindu)]

How to separate/split/ group data from excel on basis of specific row content and store it in separate datatable

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 sing…