Auto Fill Options Duplicating Same Row 2 times

%3CLINGO-SUB%20id%3D%22lingo-sub-2782045%22%20slang%3D%22en-US%22%3EAuto%20Fill%20Options%20Duplicating%20Same%20Row%202%20times%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2782045%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20need%20to%20make%20a%20spreadsheet%20where%20I%20am%20duplication%20a%20row%20from%20another%20sheet%20(Purchase%20line%20and%20a%20Tax%20Line)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20highlight%20the%20first%204%20cells%20and%20pull%20down%20for%20auto%20fill%20you%20can%20see%20it%20goes%20from%20i2%20i2%20%26gt%3B%20i3%20i3%20to%20i6%20i6%20%26gt%3Bi7%20to%20i10%20and%20so%20on%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20it%20to%20go%20from%26nbsp%3Bi2%20i2%20%26gt%3B%20i3%20i3%20%26gt%3Bi4%20i4%20%26gt%3B%20i5%20i5%20and%20so%20on%20see%20below%20any%20assistance%20would%20be%20great%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF('Paste%20Service%20Date'!I2%26gt%3B%200%2C'Paste%20Service%20Date'!I2%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I2%26gt%3B%200%2C'Paste%20Service%20Date'!I2%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I3%26gt%3B%200%2C'Paste%20Service%20Date'!I3%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I3%26gt%3B%200%2C'Paste%20Service%20Date'!I3%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I6%26gt%3B%200%2C'Paste%20Service%20Date'!I6%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I6%26gt%3B%200%2C'Paste%20Service%20Date'!I6%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I7%26gt%3B%200%2C'Paste%20Service%20Date'!I7%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I7%26gt%3B%200%2C'Paste%20Service%20Date'!I7%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I10%26gt%3B%200%2C'Paste%20Service%20Date'!I10%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I10%26gt%3B%200%2C'Paste%20Service%20Date'!I10%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I11%26gt%3B%200%2C'Paste%20Service%20Date'!I11%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I11%26gt%3B%200%2C'Paste%20Service%20Date'!I11%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I14%26gt%3B%200%2C'Paste%20Service%20Date'!I14%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I14%26gt%3B%200%2C'Paste%20Service%20Date'!I14%2C%22%22)%3CBR%20%2F%3E%3DIF('Paste%20Service%20Date'!I15%26gt%3B%200%2C'Paste%20Service%20Date'!I15%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2782045%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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