in B1
=indirect("A"&row($A1)*4)

drag fill down the column

In your example, A1 is omitted - it is not every 4th cell.

--
Regards,
Tom Ogilvy


"ANton Petrov" wrote in message
...
could someone help me with this, please?