Need help merging two columns in Excel 2010

[Tobolo]

First off, thanks for reading!

As the title mentions, I have two columns of data with nothing but numbers in them and I would like to combine them into one data column. Here is the tricky part, in order for the data be analyzed correctly they must merge like this:

Original
Column 1_Column 2
A B
C D
E F

Merged
Column 1
A
B
C
D
E
F

Can anyone help me figure this out?

 

[PowerEngineer]

Here's how I'd do it:

First, I'd insert new columns just to the right of your original two and then populate them with alternating numbers like this:

A 1 B 2
C 3 D 4
E 5 F 6
. . . .
. . . .

The numbers in the two columns can be generated by formula and then copy/paste-value into pure values.

I'd then cut/paste the 3rd/4th columns to the ends of the 1st/2nd columns:

A 1
C 3
E 5
. .
. .
. .
B 2
D 4
F 6
. .
. .
. .

The final step is just a sorting of the two columns by the ascending values in the second column.

 

[jolancer]

If your lookin for a more permanent hassle free solution, heres one, there maybe a better way but im not familiar with macro's, and have gotten into the habbit of using Non Volatile functions.

assuming for example
(A1) colume1 start
(B1) colume2 start

(C1) "1"
(C2) "2"

(D1) "1"
(D2) LEAVE BLANK

(E1) "=INDEX($A$1:$B$50,COUNTIF($D$1:INDEX($D$1:$D$99,$C1),1),IF($D1,1,2))"
(E2) "=INDEX($A$1:$B$50,COUNTIF($D$1:INDEX($D$1:$D$99,$C2),1),IF($D2,1,2))"

and just highligh C1 through E2 and drag all the way down twice as far as your AB colums, and replace $D$99 with whatever amount you need.

EDIT: the :$ is.... : $ <without a space, and change $B$50 to however long your colums are aswell

 

[juiio]

Assuming the data starts in A1...

=OFFSET($A$1,(ROW()-1)/2,IF(ISEVEN(ROW()),1,0))