combining two columns into one column in excel 365

Hi everyone

I have two columns in excel 365;

Column 1 A B C D
Column 2 E F G


I want to combine these two columns into one column 3 as below with ignoring blank cells.:

Column 3
A
B
C
D
E
F
G

How can I do that in excel 365? I tried the formula of Google Sheets but it is not working in excel 365.

hope to solve this issue please and many thanks in advance.

Regards