Column Referencing

[mchiodo7]

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!

[Special-K]

in Sheet2!A1
=INDEX(Sheet1!A$1:A$1000,QUOTIENT(ROW()-1,4)+2,1)
copy across and down column B

[mchiodo7]

You guys/gals/whatevas are the absolute best!