I have a series of data in Sheet 1 that needs to be cross referenced, in factors of four, in sheet 2. I know I can use the incremental tool, but I am having issues doing so. A breakdown of the problem is included below.

Breakdown - Example.

Sheet 1
Column A = Campaign | Column B = Adgroup
A2 = Campaign 1 | B2 = Adgroup 1
A3 = Campaign 2 | B2 = Adgroup 2.

Sheet 2
A1 =Sheet1!A$2 | B1 =Sheet1!B$2
A2 =Sheet1!A$2 | B2 =Sheet1!B$2
A3 =Sheet1!A$2 | B3 =Sheet1!B$2
A4 =Sheet1!A$2 | B4 =Sheet1!B$2
______________________________________

A5 =Sheet1!A$3 | B5 =Sheet1!B$2
A6 =Sheet1!A$3 | B6 =Sheet1!B$2
A7 =Sheet1!A$3 | B7 =Sheet1!B$2
A8 =Sheet1!A$3 | B8 =Sheet1!B$2
______________________________________

A9 =Sheet1!A$4 | B9 =Sheet1!B$2
A10 =Sheet1!A$4 | B10 =Sheet1!B$2
A11 =Sheet1!A$4 | B11 =Sheet1!B$2
A12 =Sheet1!A$4 | B12 =Sheet1!B$2

Etc.

Any help would be appreciated!