Paste datatable variables to another datatable in different position

Hi all,
i have the current scenario that i’d like to solve.

I have data retrieved from a site structured like this.

Datatable:
Name_1
Name_2
Info_1
Info_2
Address_1
Address_2
Name_3
Name_4
Info_3
Info_4
Address_3
Address_4

What i would like to obtain is a new datatable like this one:

Col 1 |Col 2 |Col 3 |Col 4 |Col 5 |Col 6 |

Name_1 |Name_2 |Info_1 |Info_2 |Address_1 |Address_2 |
Name_3 |Name_4 |Info_3 |Info_4 |Address_3 |Address_4 |

So as you can see i’d like to transpose:

  • the first row, that i find in the first table, to the first row first column of the second table
  • the second row of the first table to the first row second column of the second table

And so on until i get to the seventh row of the first table which i will append to the second row first column of the second table.

Any guesses on how to do so?

Also, how do i find out when to stop the loop?
(Assume i will always have a number of rows multiple of six so each column of my second table will be fully populated).

Many thanks in advance!

@andrea.pillot
find some starter help here. Configure the BlockSize Variable to your Blocksize = 6
Transponse_BlockSeries_ByBlockSize.xaml (11.7 KB)

Some explanations on the used building blocks you can refer here:

2 Likes

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