i need to transpose 18000 rows of 1 colums into 6000 rows of 3 columns
source array is
<tbody>
</tbody>
target array is
<tbody>
</tbody>
When i use {=TRANSPOSE(c2:c4)} and i try to copy into the following rows, the row reference is only augmented with 1 instead of 3 and i get {=TRANSPOSE(c3:c5)} instead of {=TRANSPOSE(c5:c7)}.
is there another way to solve this?
txs,
fva2600
source array is
Termid | Language | Text description |
1 | EN | words and sentences |
1 | FR | mots et phrases |
1 | NL | woorden en zinnen |
2 | EN | more of this |
2 | FR | plus de ça |
2 | NL | meer van dat |
<tbody>
</tbody>
target array is
Termid | EN | FR | NL |
1 | words and sentences | mots et phrases | woorden en zinnen |
2 | more of this | plus de ça | meer van dat |
<tbody>
</tbody>
When i use {=TRANSPOSE(c2:c4)} and i try to copy into the following rows, the row reference is only augmented with 1 instead of 3 and i get {=TRANSPOSE(c3:c5)} instead of {=TRANSPOSE(c5:c7)}.
is there another way to solve this?
txs,
fva2600