Output cell every nth row

Question 1

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

Example every 3 rows:

Question 2

or you can do it with QUERY:

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

Question 3

Put this formula in A2:

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

Question 4

use MOD:

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

Question 5

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)

player0 · Answer 1 · 2021-11-24T01:48:01

or you can do it with QUERY:

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

idfurw · Answer 2 · 2021-11-24T02:06:27

Put this formula in A2:

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

player0 · Answer 3 · 2021-11-24T01:45:18

0

use MOD:

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

player0

2021-11-24 01:45:18

Hi, I want to do the opposite. I have the values in col B and I want to spill them in col A every nth row - if that makes sense.

bewix

Cooper · Answer 4 · 2021-11-24T02:53:35

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)

In other languages