Transpose Rows to columns but in increments of 3 columns

[devang3110]

Hi,
So I have data organised as:

[TABLE="width: 710"]
<tbody>[TR]
[TD="class: xl65, width: 71"]16.66666667[/TD]
[TD="class: xl65, width: 71"]0[/TD]
[TD="class: xl65, width: 71"]16.66666667[/TD]
[TD="class: xl65, width: 71"]0[/TD]
[TD="class: xl65, width: 71"]0[/TD]
[TD="class: xl65, width: 71"]0[/TD]
[TD="class: xl63, width: 71, align: right"]16.66666667[/TD]
[TD="class: xl63, width: 71, align: right"]0[/TD]
[TD="class: xl63, width: 71, align: right"]16.66666667[/TD]
[TD="class: xl64, width: 71, align: right"]16.66666667[/TD]
[/TR]
</tbody>[/TABLE]

And I want to transpose it in sets of 3, like:

[TABLE="width: 213"]
<tbody>[TR]
[TD="class: xl65, width: 71"]16.66666667[/TD]
[TD="class: xl65, width: 71"]0[/TD]
[TD="class: xl65, width: 71"]16.66666667[/TD]
[/TR]
[TR]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]0[/TD]
[TD="class: xl63, align: right"]16.66666667[/TD]
[TD="class: xl64, align: right"]16.66666667[/TD]
[/TR]
</tbody>[/TABLE]


Can anyone help me? I need to do this with a lot of data :/

Thanks!

 

[XOR LX]

Hi.

Assuming your original list is in A1:J1, enter this in your first cell of choice:

=INDEX($A$1:$J$1,3*(ROWS($1:1)-1)+COLUMNS($A:A))

Copy across and down as required.

Regards

 

[devang3110]

Hi.

Assuming your original list is in A1:J1, enter this in your first cell of choice:

=INDEX($A$1:$J$1,3*(ROWS($1:1)-1)+COLUMNS($A:A))

Copy across and down as required.

Regards

Works like a charm! thanks!

 

[XOR LX]

You're welcome!

Cheers