Complex Filter Datatable Question - Process All Rows Pertaining to 1 Cell in 1 Column

[ppr (Peter Preuss)]

@Sc100

What is the best way to go about making sure that rows 2 – 6 are seen as belonging to the top Column A cell, and rows, and rows 8 – 12 seen as belonging to the bottom Column A cell?

two of a few techniques canbe applied:

Fiiling up - Group By

• after read in a datatable we can fillup the missing a values
• then with a group by we can build and process the groups

How to match data between 3 columns

when readin int the excel into a datatable (read range) we would expect following result Group1|1|true |2|True … so we would filling up the missing GroupX column values grouping the data on GroupDocs processing / evaluating the groups For filling up, have a starter help here: FillUp_BlockBlanks.xaml (9.3 KB) Grouping data have alook here:

Index calculation - Skip/Take Segmentation

• calculate all rows index where A col is not empty
• then slice the data with skip and take like
  dtVar.AsEnumerable.Skip(0).Take(6-0),dtVar.AsEnumerable.Skip(6).Take(X-6) …

We also would recommend to filter out any blank seperator rows before running any aproach mentioned above