Appending Arrays of Cells filled with Strings

[Legacy 366625]

Hello everyone,

I am looking for a way to append a column from a table to a column in another table, and fill a column in a third table with the result, without using VBA or any add-ons (these last two restrictions come from our IT policies). There is no problem using a CSE formula. Here is a simplified example:

Table4[Col1] = {a,b,c}
Table5[Col1] = {d,e}

ResultTable[Col1] = {a,b,c,d,e}

The actual data I am working with is hundreds of lines long, and the length varies, but the data will always be in exactly two tables. Once I have this working, I want to use additional formulas to eliminate duplicates from the combined array, which I plan to do using the method at the link below; if removing the duplicates somehow helps with the combination of the arrays, that would be great.

http://www.mrexcel.com/forum/excel-questions/460154-formula-extract-unique-values-array.html

After reading several other posts, I thought the CHOOSE() function would do what I wanted, but the closest I can get is this:

=CHOOSE({1,2},INDIRECT("Table4[Col1]"),INDIRECT("Table5[Col1]")) => {a,b,c ; d,e}
=CHOOSE({1;2},INDIRECT("Table4[Col1]"),INDIRECT("Table5[Col1]")) => {a,e}

Is there a solution to my problem?

I am using Office Pro Plus 2013 in Windows 7.

Thanks!

 

[Legacy 366625]

Any ideas? Thanks!