Copying/Filling Formulas Down a Column with Spaces Between

[BKGLTS]

Hello,

I have looked this up online and tried a few different things, but none have worked.
It seems to be something many people have done in the past, but for some reason none of the solutions work for me.

For example:
Sheet2 A1 =Sheet1!A1

I need to fill down on Sheet2 Column A with skips/blank cells.

So the result on Sheet2 would be:
A1=Sheet1!A1
A2=Blank
A3=Blank
A4=Sheet1!A2

A5=Blank
A6=Blank
A7=Sheet1!A3

and so on...


Selecting the pattern and simply dragging does not work.
I also tried the relative location thing with no success and a couple other things I can't recall.

Thank you for your help.

Sincerely,
B
​

 

[Special-K99]

in Sheet2!A1
=IF(MOD(ROW(A1)-1,3)=0,INDEX(Sheet1!A$1:A$1000,(ROW(A1)-1)/3+1,1),"")

 

[BKGLTS]

Thank you Special-K99! This seems to be working.
I don't quite understand it though.
Tried to work through it to see how it works but cant quite get it.

Thank you!
B​

 

[Special-K99]

If the row number of each row -1 is a multiple of 3 then we need the data from Sheet1 otherwise produce a blank.

Row 1 ==> we need Sheet1!row 1
Row 4 ==> we need Sheet1!row 2
Row 7 ==> we need Sheet1!row 3

y=mx+c from school maths
m=(3-1) / (7-1) = 1/3
So the row we want to extract from Sheet1 is 1/3 of the original row + an offset.
Using y=mx+c the formula ends up as

(original row - 1) * 1/3 + 1
hence

(ROW(A1) - 1) /3 + 1

 

[BKGLTS]

I would have never got that.
Thank you for explaining!