Looping an index transposing formula

Hi,

I am trying to take my data and transpose (loop?) every 18 cells into a seperate Row. I have gotten it to transpose a single set of what I need, but haven't been able to get further then that. Any help would be much appreciated. I have never used excel VBA before, so I am trying to do it all by indexing. I am using Excel 2013 - but I tend to use .xls so others can use the file.

I have gotten this far: =INDEX($E$2:$E$6068, COLUMNS(G$2:G2)*18-18+COLUMNS($G2:G2))

Thanks!

You were almost there. Just add *ROW(A1)

=INDEX($D$2:$D$6068, COLUMNS(F$2:F2)*18*ROW(A1)-18+COLUMNS($F2:F2))
Does that work for you?