Incrementing in a group pattern

[kvcf111]

Hi guys,
is it possible to increment values by 1 in a group of cells in a column?
I mean by i have a column, filled from starting from A1 with number 1, and i have 1 in A2, A3 and A4, and starting by A5 i have 2 in it, same in A6,A7 and A8. And i want this pattern to continue with 3,4,5,6,7 but it only increments in every 5th cell. so the next 4 cells will have value 3, and the 4 after that will have value 4.

Like this. But the only difference is the fact that i have letters in front of it, so not just the numbers. So i want it to look like this:
NKK2019
NKK2019
NKK2019
NKK2019
NKK2020
NKK2020
NKK2020
NKK2020
NKK2021
NKK2021
NKK2021
NKK2021
etc...
Is there a way to fill it fast? I can't just drag it down sadly or add 1 to every cell.

[Pauleyb]

You could use some ROW() and INT() and MOD() formulas to do this, but I'd recommend just hardcoding a 1 in A1, A2, A3, and A4. Then the formula in A5 is =A1+1. Grab that formula and drag down as far as you wish.

Now I see you want a quick method as you can't drag it down. Not quite sure what you want, as there are many ways to quickly paste. In my example above, just copy A5, select the range where you want that formula to apply (using the shift key to quickly select an array of cells), then hit paste.