ok, looks great. but i had one question:

let's say there are three, or 5 variables, what do i revise? for example on
sheet three the formula is:

=OFFSET(Sheet2!$A$1,INT((ROW(A1)-1)/4),)&"-"&OFFSET(Sheet2!$B$1,INT((ROW(A1)-1)/4),)

if i am guessing right, the "/4" near the end there is the result of the
fact that this sheet only has three columns and there are 12 numbers,
therefore 3x4=12? so if there were 18 total (3 per column in sheet 1) the"/4"
would change to "/6"?

Looks very promising. Thnaks again