How to insert rows into columns from another sheet?

Question

I'm trying to prefill a template with repeating data in a column like this: Sheet1:

A1
Offer Name:
Offer URL:
Network:
Payout $:
Share%:

Offer Name:
Offer URL:
Network:
Payout $:
Share%:

...

What I'd love to do is insert data from Sheet2, which is in a row: Sheet2:

A1      B1      C1          D1  E1
name1   link1   network1    1   5%
name2   link2   network2    1   5%

and have that prepopulate Sheet1 like this:

A1          B1
Offer Name: name1
Offer URL:  link1
Network:    network1
Payout $:   1
Share%:     5%

Offer Name: name2
Offer URL:  link2
Network:    network2
Payout $:   1
Share%:     5%

So I could drag the filler down in the Sheet1 and have it prefill as much content as there is in Sheet2. I've tried concatenate, but formula doesn't work.

Is it possible to do with a formula?

Answer 1

Assuming Sheet1 starts in A1 with Offer Name: and name1 is in Sheet2 A1 please try in Sheet1 B1 copied down to suit:

=OFFSET(Sheet2!A$1,INT(ROW()/6),MOD(ROW()-1,6))  

You might series fill Sheet1 ColumnA by selecting A1:A12 and dragging the fill handle down to suit. If desired to remove the 0 from B6, B12 etc. then filter ColumnA to select (Blanks) and delete the zeros. Also use filter if required to format the percentages.