I have this data set which i want to split into two columns using a formula. I know i can use something like
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.