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)
Columns A&B completed 180,400 Lines But Column C stopped at line 3,025 and
filled in 0's the rest of the way down. Any ideas on how to fix this?