How to combine multiple list in excel?

Hi there, I prefer to combine databases in stand out from left-to-right.

Recommendations my data (each mail represent a different cell)

A B C
VE HAD E F
H H I

And I’d like to see the result to get this:

A
B
C
D
E
F
G
H
I

How could i do this

========

PS:I’ve found a lot of answers merely want my own results trend like that (below).I tend not to want the actual result to seem like this:
A
D
G
B
E
H
C
F
I

you are most likely better away from with VBA for such as this
but as you are are merely counting through 3’s…you need to use a system too
if your table starts at the top A1 in order to C3
subsequently copy&paste the following in D1

=INDIRECT(ADDRESS( INT(ROW(A3)/3), MOD(ROW(A3), 3)+1))

subsequently fill down

edit-
received your meaning.
we answered back again.
heres a copy

an individual did very good to switch it to count by means of 4’s.that 0 you might be getting is usually replaced by way of a “”
the easiest way to fix such as this is to just make use of an IF() declaration and copy&paste the formula.
copy&paste the following in E1

=IF(INDIRECT(ADDRESS( INT(ROW(A4)/4), MOD(ROW(A4), 4)+1))=0, “”, INDIRECT(ADDRESS( INT(ROW(A4)/4), MOD(ROW(A4), 4)+1)))

subsequently fill down.
notice in which both affliction and wrong sides on the IF functions are the same.the circumstances just checks for =0 to visit to true.