combine columns of data vertically without losing original order

[1001joec]

How can I combine the two columns of data into one column without losing the original order? Column one takes precedence over column two and spaces must be omitted. The attached example shows what a combined column should look like.

 

[Smallman]

Hi 100joec

There are probably other ways but with VBA I would do this.

Sub shifto()
   Range("b3", Range("B" & Rows.Count).End(xlUp)).SpecialCells(2).Copy Range("H" & Rows.Count).End(xlUp)(2)
   Range("c3", Range("c" & Rows.Count).End(xlUp)).SpecialCells(2).Copy Range("H" & Rows.Count).End(xlUp)(2)
End Sub

Take care

Smallman

 

[azumi]

Example solution with array formula, pls find file attach.

Cheers