Non-Adjacent Rows Fill Down

[Cunning]

I have a spreadsheet which links the cells in one sheet with cells in another... however, they do not run concurrently.

Sheet1 has


A1 -
A2 - 1
A3 - 2
A4 - 3

etc

Sheet 2 should have

A1 - 1
A2 -
A3 -
A4 - 2
A5 -
A6 -
A7 - 3

etc.

Is there an easy way to do this through a fill down using an offset or indirect formula?

 

[Steve=True]

2 potential ways.

1) insert 2 blank rows in between 1 and 2 and between 2 and 3 and then select rows with 1 and 2 as well as the blanks between and after 1 and 2. Then just grab the bottom black area of the selected range and drag/fill down. Numbers will increment with spaces between.

2) longer process, but You can add a new column with data of 1 next to one, 2 next to 2, etcetera. Then in the same new column, below the end of the data, add 1, 1, 2, 2 and fill down as far as you need to match your data, then sort the helper column along with your data. You will now have addtional rows between the data.