fill a column with values from 2 columns in excel

I want fill a column continuously with values from 2 columns

Col A Col B

1 4
3 6
7 8
9 11
10 14


Result
1
4
3
6
7
8
9
11
10
14

A non-macro solution. With values in columns A:B,put this formula in G1 and copy down:

=INDEX(A:B, CEILING(ROW()/2,1), MOD((ROW()+1),2)+1)

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

Could someone actually do this ASAP to C column of the file attached using INDEX function, because I get an error message saying bad formula every single time I try. It would really help me to understand the logic of this.

Thanks in advance!