Join two columns

Get Help
1

Hi!
How can I join two columns like this:

I have column A and B:

Column A
abc
def
ghi

Column B
jkl
mno
pqr

And I want this result:

Desired column
abc
def
ghi
jkl
mno
pqr

2

Hi @Helena
You would do a union or full outer join depending on your database type:
https://www.metabase.com/docs/latest/users-guide/join.html