ran this formula In F1 enter
=OFFSET(A$1,(ROW()-1)/30,0)&" - "&OFFSET(D$1,MOD(ROW(D1)-1,30),)
In G1 enter
=OFFSET(B$1,(ROW()-1)/30,0)
in H1 enter
=OFFSET(C$1,(ROW()-1)/30,0)

rows A and B ran complete 180,400 lines but row c stopped at line 3,025 and
just filled zeros in the rest of the way. I can not seem to figure out how to
fix this. Any suggestions?