I have this data set which i want to split into two columns using a formula. I know i can use something like

```
=MOD(ROW(A1),2)
```

down along the adjacent column, which puts a 1 or 0 in each row which i can then filter.

I wonder if there is a simpler method using a formula?

```
A
B
C
D
E
F
```

I want to end up with this in another 2 columns.

```
A A B
B C D
C E F
D
E
F
```

I have tried `=OFFSET($A$2,2,-1)`

in Column B1 and `=OFFSET($A$2,4,-1)`

in cell B2, dragging down does not increment properly, i need to increment the "2" by 2 on each new row.