I am so lost and looking for assistant in formulating a table cell to search for matching text and turning it into a list. example below.


Table one has the following:
Table 1:
..........A..........B..........C..........D
1.....Alpha.....1241......152.......221
2.....Alpha.....9421......643.......234
3.....Bravo.....2441......453.......112
4.....Alpha.....7864......235.......890
5.....Delta.....1256......124.......346
6.....Bravo.....2441......453.......112



so i want Table 2 to look at "table 1 - Column A" and make a list of name that are not already in the table 2 list for Column A in table 2.

Table 2:
..........A..........B..........C..........D
1.....Alpha
2.....Bravo
3.....Delta



is there a way to make this formula for Table 2 to look at table 1 column A to combine the names that are multiple?