Group By | For each row in each group - Please Help

[ppr (Peter Preuss)]

Variables:

Sample data (here we react on Line as SplitText)

Flow for getting the group Member Rows

arrTriggerIndex =

(From i In Enumerable.Range(0, dtData.Rows.Count)
Where dtData.Rows(i)(0).ToString.Trim.Equals(strSplitTrigger)
Select x = i).toArray

arrTriggerIndex.Select(Function (x) x +1).toArray
arrSkippers.Zip(arrSkippers.Skip(1).Append(dtData.Rows.Count + 1), Function (x,y) new Int32(){x,y - x - 1}).ToList
ListSkipTakePairs = arrSkippers.Zip(arrSkippers.Skip(1).Append(dtData.Rows.Count + 1), Function (x,y) new Int32(){x,y - x - 1}).ToList

Inspections:

Loop Inspections:

[HowTo] LINQ - First Start # Skip | Take | SkipWhile | TakeWhile Operator

This HowTo gives an introductory overview of the partition Operators: Skip, Take, SkipWhile, TakeWhile Introduction The partition operators are used to fetch a particular subset from a set of items. The returned subset is formed by the contiguous items that are matching the provided condition. Skip / Take Operator The Skip Operator will omit the subsequent items from the given start for a given length and will return the remaining items The Take Operator will return the subsequent items fr…

As An alternate you can also modify the following approach

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: