Creating a column in a table by appending the rows of 2 different columns in different tables.

[juststarting]

Let's say I have a column A in Table X that contains 10 entries

I have another column B in Table Y that contains 5 entries.

They both are type Text.

I have an empty column in Table Z, with the name "Combined".

I want to be able to import or copy the entries from X[A] and Y[B] and append all the rows so that the Column "Combined" in Table Z has 15 values.

I want Column "Combined" to be a physical column, not a virtual one.

It would also be great how to get rid of duplicate values in Column "Combined" if required in the future.

The source of all this data is google sheets.
Thanks!