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