Make 3 rows relative to 1 row on previous sheet, then REPEAT!

Hey Guys,

Basically, I have a long list of records and need to rearrange it so that in the new sheet, the data will span 3 rows. So, I created formulas to place the data from the first sheet where I want it to be on the second. So on the second sheet, the first 4 rows are relative to the first row in the first sheet. I would like the next four rows to be relative to the second row, and so on.

However, simply copying the first 4 rows and pasting makes the next group relative to row 5, not row 2.

Screen Shot 2013-06-08 at 12.47.30 AM.jpg

I tried selecting the just the first column and filling down, but rather than starting with row 4, it starts with row 14.

I there any way to get excel to continue the pattern in my groups of rows?

Any help or ideas would be greatly appreciated.
~Bob

Here is a sample file!


AST.xlsx

Thanks!

find the attachment

Thanks guys! This is awesome!

I'm going to go without the macro! :-)

Take care,
~Bob