Copy cell from every nth row
I would like to get the names in each name from this google spreadsheet and put it in a new column. The names will represent every nth line.
+4
source to share
2 answers
In B2 try:
=offset(A$1,3*(row()-1)-2,)
As the formula is copied down, offset from A1 is increased by three, without offsetting the column. In the second (starting line) 3 * (2-1) -2 is 1, so A2 is returned. On the second output line, 3 * (3-1) -2 returns 4, so A5 is returned, etc.
+1
source to share