=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
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