Column to the right (not rows) for each loop

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

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

1 Like

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 :slight_smile:

For now I used a mediocre solution.
See below


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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.