I have a excel spreadsheet like:

What I would like:

Thus, what I am trying to achieve is for the current cell to take the value of the cell directly below value and repeat, skipping each of the directly below cells.

For example, cell `B2`

will take the value 10.62 (i.e. cell `B3`

); then cell `B3`

will be skipped; then, cell `B4`

will take value of 13.26 (i.e. cell `B5`

), and following suite...

I have tried this formula:

```
=INDEX(B2:$B$4518,ROWS(B2:B2)*2)
```

Then, selecting that row and the row below, which doesn't have any formulae, and dragging down. But, sadly unless I only drag down one then reselect it doesn't work correctly. It seems to take the first selected cells value and then adds 1.