How to merge row n with row n+1

[ppr (Peter Preuss)]

@stela_zh

find an anproach on:

• doing a merge of n and n+1 row
• handling a take from first when botw rows doe have a value
• use nothing when both rows do not have a value

find starter help here:
MergeNonEmptyValues_RowNWithNextRow.xaml (12.1 KB)

find some introductions to the used concepts here:

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…