Copy all the details that are related to the 1st column

[ppr (Peter Preuss)]

there are several options to implement it. Feel free to pickup this one most matching to your skill set:

@Priyanka_Ramesh

Find the index of the next invoice number(ie the value is available in the first column) - cell 5 .
By using the take function with dt.asenumerable.take(5) this will consider only first 5 rows.

• finding index: for each row / if check and memorizing row index e.g. as the output index from for each
• calculating the segment start index and length
• using skip T take method for slicing the table

For each row

• loop over the rows
• detect when a segment is starting / ending
• transfer the datarow from segment, when collecting to a helper datatable

we do know that it can be done quickly but it has to handle specifics e.g. first row, end of loop …

TakeWhile Approach
Vars:

Segmenting:

Writing:

Demo:

Find starter help here:
DTSlice_BySegmentSize_ToTableList.xaml (10.5 KB)

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