How to group the rows which has similar information

[thima (Himabindu)]

Hi All,

I want to group the rows which has similar values in excel how to do that.Please hep me.

Regards,
HimaBook1.xlsx (13.9 KB)

[kadiravan_kalidoss (Kadiravan K)]

Hi @thima,

Can u provide expected output in sheet2

Thanks!

[thima (Himabindu)]

Please refer output in sheet2

Book1.xlsx (16.0 KB)

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