I have a huge spreadsheet with information arranged in the following way:
[TABLE="width: 500"]
<tbody>[TR]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]98[/TD]
[TD]68[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]90[/TD]
[TD]100[/TD]
[TD]75[/TD]
[TD]80[/TD]
[TD]70[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD]50[/TD]
[TD]60[/TD]
[TD]70[/TD]
[TD]90[/TD]
[TD]90[/TD]
[/TR]
</tbody>[/TABLE]
etc. (total table columns A - DX, rows 1 - 75)
What I need to have is each row transposed into 3 columns at a time so each single row, as they stand currently, becomes 40 rows of three columns like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]98[/TD]
[TD]68[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]90[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]75[/TD]
[TD]80[/TD]
[TD]70[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD]50[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]70[/TD]
[TD]90[/TD]
[TD]90[/TD]
[/TR]
</tbody>[/TABLE]
I know how to do this if I take one row at a time and transpose it to a column, and then use an index function to turn it into 3 columns, but if I try to do multiple columns it will not function at all. If there is a way I can perform this task without having to copy and paste for all 75 rows I would be oh so grateful!
Thank you for any help you may be able to provide
[TABLE="width: 500"]
<tbody>[TR]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]98[/TD]
[TD]68[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]90[/TD]
[TD]100[/TD]
[TD]75[/TD]
[TD]80[/TD]
[TD]70[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD]50[/TD]
[TD]60[/TD]
[TD]70[/TD]
[TD]90[/TD]
[TD]90[/TD]
[/TR]
</tbody>[/TABLE]
etc. (total table columns A - DX, rows 1 - 75)
What I need to have is each row transposed into 3 columns at a time so each single row, as they stand currently, becomes 40 rows of three columns like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]98[/TD]
[TD]68[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]90[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]75[/TD]
[TD]80[/TD]
[TD]70[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD]50[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]70[/TD]
[TD]90[/TD]
[TD]90[/TD]
[/TR]
</tbody>[/TABLE]
I know how to do this if I take one row at a time and transpose it to a column, and then use an index function to turn it into 3 columns, but if I try to do multiple columns it will not function at all. If there is a way I can perform this task without having to copy and paste for all 75 rows I would be oh so grateful!
Thank you for any help you may be able to provide