Create New Blank Row after each 4 rows

[HiS2oKa]

For Example I have this data,
1.png

How I can insert 1 New Blank Row after each 4 rows,
To be look like:
2.png
Thanks in advance for any help

[Pepe Le Mokko]

Several possibilities described at https://www.exceldemy.com/excel-inse...every-nth-row/

[Pete_UK]

I used this formula in cell E4, so that it could be compared directly with what you want to achieve:

=IF(MOD(ROWS($1:4),5)=0,"",INDEX(A$4:A4,COUNTIF(E$3:E3,"?*")+1))

If you want it to work in column C you need to change the references to column E (shown in red above).

Hope this helps.

Pete

[HiS2oKa]

Thanks to both of you @Pepe Le Mokko And @Pete_UK

[Pete_UK]

You're welcome, and thanks for the rep.

Pete