How can I output a cell's value every nth rows

Example every 3 rows:

CodePudding user response：

or you can do it with QUERY:

=QUERY(A2:A, "skipping 3")

CodePudding user response：

Put this formula in A2:

=ArrayFormula(FLATTEN(SPLIT(REPT(C2:C4&"♦︎",3),"♦︎")))

CodePudding user response：

use MOD:

=FILTER(A2:A, MOD(ROW(A2:A)-2, 3)=0)

CodePudding user response：

Offset is relatively simple. To get an index that increases by 1 every three rows just ROUNDDOWN the ROW address by three

=OFFSET($C$2,ROUNDDOWN(ROW(A1),0)/3,0)