Looping an index transposing formula

[poetgirl916]

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!