In C1 enter:
=index(B:B,2*row()-1)
and copy downward. In D1 enter:
=index(B:B,2*row())
and copy downward:
If you need to enter the formulas below row#1, replace:
row()
with:
rows($1:1)
Gary's Student
- 191
- 5