Group data from excel table with same values and store them in for each loop to store to pass web form

[ppr (Peter Preuss)]

@Yusuf_Rahmaniac

have a look on the folling posts, as they are handling quite similar scenario:

Iterate DT For Each Group

@COOLBOT Just a little starter help: Readin the Excel into a DataTable - Read Range e.g. Variablename: dtData - Assumption Column Order is of DataType: Int32 Creating a list of Groups (Distinct Orders) - Assign Activity [grafik] DataType Orders: List(Of Int32) Statement: dtDemo.AsEnumerable.Select(Function (row) row.Field(Of Int32)(“Order”)).Distinct().ToList Iterate over the Groups Filter the original DataTable to all Rows belonging to the Current Group from Iteration - dtFiltered I…

Isolate multiple rows with duplicate column values

Say I have the following table: [image] How should I isolate the rows where the first 4 column values are the same (So the rows highlighted in yellow and orange) ? I want to store all the ones with duplicates into a separate sheet and the ones without duplicates into another sheet I looked at this link but the method in here does not do exactly what I need to do, (Remove Duplicate Rows By Combination of Multiple Column Values)