i have the current scenario that i’d like to solve.
I have data retrieved from a site structured like this.
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!