Column to the right (not rows) for each loop

[JVDS (Jesse)]

Hi,

I’m trying to achieve what’s shown below.
For each loop we move a column to the right until the for each loop is finished.

How can I make this happen? Can’t find a proper answer on the forum.

Edit:
More clarification this is what it should look like to get this outcome

FOR EACH: Working in row 1
 FOR EACH: Working in row 1 per project
	Loop 1: Project 1 in I
	Loop 2: Project 2 in J
	Loop 3: Project 3 in K
FOR EACH: Working in row 2
 FOR EACH: Working in row 2 per project
	Loop 1: Project 1 in I
	Loop 2: Project 2 in J
	Loop 3: Project 3 in K

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

[JVDS (Jesse)]

Thanks
I’ll look in to it for future reference, for now it was too complicated for me to instantly see it as a solution

For now I used a mediocre solution.
See below

For the write cell I used: stringCIndex(cIndex).ToString + indexRow.ToString