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.