copy different Horizontal data to vertical

[johnny52]

=IFERROR(INDEX(A$1:H$9,CEILING(ROWS(E$1:E2)/8,1)*4-3,MOD(ROWS(E$1:E2)+7,8)+1),""

This formula works for my 8 columns and 1 row of horizontal data (converts it to vertical in column i1 thru i8)

How can I copy this formula to a lower part of the worksheet where I have different row data (but the same columns),not the constant (E$1:E2) from just the first row

I can't seem to follow what this formula is doing (E$1:E1)/8,1)*4-3 and MOD(ROWS(E$1:E1)+7,8)+1),"") looks like it just reading that first row

 

[AlphaFrog]

Change the A$1:H$9 to the "different row data". The rest of the formula is the same.

 

[johnny52]

Change the A$1:H$9 to the "different row data". The rest of the formula is the same.

Thanks, but I kind of want a formula to change this automatically ....the worksheet is quite large

 

[AlphaFrog]

Are we to assume that "different row data" means you want the formula to change to the next 9 rows every time you drag it down nine rows?

 

[johnny52]

Are we to assume that "different row data" means you want the formula to change to the next 9 rows every time you drag it down nine rows?

yes if that's possible

Thanks