Auto Fill Options Duplicating Same Row 2 times

Copper Contributor

I have the need to make a spreadsheet where I am duplication a row from another sheet (Purchase line and a Tax Line)

 

When I highlight the first 4 cells and pull down for auto fill you can see it goes from i2 i2 > i3 i3 to i6 i6 >i7 to i10 and so on

 

I need it to go from i2 i2 > i3 i3 >i4 i4 > i5 i5 and so on see below any assistance would be great 

 

 

=IF('Paste Service Date'!I2> 0,'Paste Service Date'!I2,"")
=IF('Paste Service Date'!I2> 0,'Paste Service Date'!I2,"")
=IF('Paste Service Date'!I3> 0,'Paste Service Date'!I3,"")
=IF('Paste Service Date'!I3> 0,'Paste Service Date'!I3,"")
=IF('Paste Service Date'!I6> 0,'Paste Service Date'!I6,"")
=IF('Paste Service Date'!I6> 0,'Paste Service Date'!I6,"")
=IF('Paste Service Date'!I7> 0,'Paste Service Date'!I7,"")
=IF('Paste Service Date'!I7> 0,'Paste Service Date'!I7,"")
=IF('Paste Service Date'!I10> 0,'Paste Service Date'!I10,"")
=IF('Paste Service Date'!I10> 0,'Paste Service Date'!I10,"")
=IF('Paste Service Date'!I11> 0,'Paste Service Date'!I11,"")
=IF('Paste Service Date'!I11> 0,'Paste Service Date'!I11,"")
=IF('Paste Service Date'!I14> 0,'Paste Service Date'!I14,"")
=IF('Paste Service Date'!I14> 0,'Paste Service Date'!I14,"")
=IF('Paste Service Date'!I15> 0,'Paste Service Date'!I15,"")

1 Reply

@UASMarc 

Let's say the first formula is in row 2. Enter

 

=IF(INDEX('Paste Service Date'!I:I,QUOTIENT(ROW()+2,2))>0,INDEX('Paste Service Date'!I:I,QUOTIENT(ROW()+2,2)),"")

 

and fill down. If the first formula is in another row, you'll have to change the +2: subtract 1 for each row down. So for example if the first formula is in row 5, use -1 instead of 2