Combining two sets of data, showing one instance of each entry

Hi,

I have two columns of data, Tables 1 and 2 in the attached file, and I would like to have in Table 3 a list containing each item (AAAA, BBBB etc) in columns A and B.

I could paste the data from columns A and C into column E and then sort in alphabetical order, before deleting the duplicates, but there must be a cleverer way of achieving this result. It would be great if the solution was in some way dynamic because I need to do this more than once for ranges of different sizes.

Can someone please suggest a solution?

Thanks!

Hi there.

We created 2 dynamic ranges using this formula.

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Then in E2 and copy down this ARRAY formula.

Formula:

Please Login or Register  to view this content.

-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.