Transpose Rows to columns but in increments of 3 columns

[devang3110]

Hi,
So I have data organised as:

16.66666667

0

16.66666667

0

0

0

16.66666667

0

16.66666667

16.66666667

<tbody>
</tbody>

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

16.66666667	0	16.66666667
0	0	0
0	16.66666667	16.66666667

<tbody>
</tbody>

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