'Jump certain number of cells when dragging formula down on Google Sheets

I need to create a fórmula that when it is dragged down it jumps a certain pre defined number of cells. For example, I have this column:

However I want a formula that when I drag down it jumps 6 rows, something like =A(1+6) in the second row and so on, so it gets to look like this:

Is there a "pythonic" way to do that or I need to create some regexextract in a new column + query formula getting only non blank cells?

google-sheets

Solution 1:^[1]

Try in B2

=offset($A$1;5*row(A2)-10;)

try instead:

=QUERY(A1:A; "skipping 5"; 0)

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	Mike Steelson
Solution 2	player0