Combining two Filter formulas in one

[Anonymous321]

Hello
I want to have a filter formula that contains two arrays of data while also avoiding duplicates. I've inserted two tables below as an example, but in short I want a filter formula that contains the data from both of these tables while avoiding the duplicates.

Table 1

Fruit	Colour
Apple	Red
Banana	Yellow
Pear	Green

Table 2

Fruit	Colour
Apple	Red
Grape	Purple

Obviously this is a very simple example but in this case the Filter formula would list the 3 pieces of fruit from the first table but only one from the second as there's a duplicate in there.

Any help will be appreciated
Thanks, Aidan

Note: The two pieces of data in my original document on in different sheets

 

[Fluff]

What is your expected output?

 

[Anonymous321]

What is your expected output?

Simply I want a list that combines the data from two sets of tables while avoiding duplicates. Maybe the filter formula is not the best way to go about it, but perhaps the formula would look something like this
=unique('Sheet1'A14:A9999&'Sheet2'A14:A9999) This didn't work because the cell content overlapped

 

[Fluff]

Are you just looking for the distinct values in col A?

 

[Anonymous321]

Are you just looking for the distinct values in col A?

Yes

 

[Fluff]

Ok, how about

=LET(RngA,Sheet1!A14:A9999,RngB,Sheet2!A14:A9999,ra,ROWS(RngA),s,SEQUENCE(ra+ROWS(RngB)),I,IF(s<=ra,INDEX(RngA,s),INDEX(RngB,s-ra)),UNIQUE(FILTER(I,I<>0)))

 

[Anonymous321]

Worked a charm. Thank you so much ?

 

[Fluff]

You're welcome & thanks for the feedback.