Column to the right (not rows) for each loop

[ppr (Peter Preuss)]

@JVDS
have a look here as LINQ and Cartesian Product has potential to solve it:

How to get the columnname of a specific value in a row without getting knowing the column name or row

@dhennespiritu Find an introduction into an alternate approach: we can do it with 2 steps (first Build datatable is simualting readin the data) [grafik] given some data: [grafik] And the configuration of searchtem as variable: [grafik] With the help of some techniques we can quickly setup Enumerable.Range is creating a sequence starting by the start value with a given length: [grafik] A cartesian product brings the elements into tuples from each Set 1: A,B,C,D Set 2: 1,2 Result A1…