# 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