Function to count number of rows and insert a value

Hi All

Hoping you can help-I am looking or a function (row or countif I presume) that will count the number of cells/rows and insert a value after a certain count.

I'm sure there is a fairly simple formula, but can't seem to get it

thanks

Ryan