Create 4 New Blank Row between data

[ala995]

For Example I have this data,


How I can insert 4 New Blank Row between my data
To be look like

I appreciate any help guys

 

[JamesCanale]

MrExcelPlayground13.xlsx
	A	B
1	Price 1	Price 1
2	Price 2
3	Price 3
4	Price 4
5	Price 5
6	Price 6	Price 2
7	Price 7
8	Price 8
9	Price 9
10	Price 10
11	Price 11	Price 3
12	Price 12
13	Price 13
14	Price 14
15	Price 15
16	Price 16	Price 4
17	Price 17
18	Price 18
19	Price 19
20	Price 20
21	Price 21	Price 5
22	Price 22
23	Price 23
24
25
26		Price 6
27
28
29
30
31		Price 7
Sheet14

Cell Formulas
Range	Formula
B1:B115	B1	=IF(MOD((ROW(INDIRECT("1:"&ROWS(A1:A23)*5))-1)/5+1,1)=0,INDEX(A1:A23,(ROW(INDIRECT("1:"&ROWS(A1:A23)*5))-1)/5+1,1),"")
Dynamic array formulas.

 

[ala995]

@JamesCanale
Thanks, But didn't work with me i dont know why.
I copy you formula then paste it in B1 then i down it then i get this result..

 

[ala995]

And one more question please,
Which number should i play around if i need three blank row instead of four ...

 

[JamesCanale]

Try "Ctrl-shift-enter" in the first cell.

 

[ala995]

Try "Ctrl-shift-enter" in the first cell.

It's working fine now, Thanks you very much.

How can I make three blank rows instead of four?

 

[JamesCanale]

CHANGE ALL THE 5'S TO 4'S

=IF(MOD((ROW(INDIRECT("1:"&ROWS(A1:A23)*4))-1)/4+1,1)=0,INDEX(A1:A23,(ROW(INDIRECT("1:"&ROWS(A1:A23)*4))-1)/4+1,1),"")