Extract data from a table to a list

Hello Excel friends
As you can see from this table I'm tring to extract only the animals without the #N/A

thank you for your help

	A	B	C	D	E	F	G
1	#N/A	#N/A	#N/A	#N/A	#N/A		Result
2	dog	#N/A	#N/A	cat	#N/A		dog
3	#N/A	#N/A	#N/A	#N/A	#N/A		Cat
4	#N/A	#N/A	#N/A	#N/A	#N/A		rat
5	#N/A	#N/A	#N/A	#N/A	#N/A		bird
6	#N/A	rat	#N/A	#N/A	#N/A		Cat
7	#N/A	#N/A	bird	#N/A	#N/A
8	#N/A	#N/A	#N/A	#N/A	#N/A
9	#N/A	#N/A	#N/A	#N/A	cat
10	#N/A	#N/A	#N/A	#N/A	#N/A

Hello AliGw
thank you for the answer, But I don't need a Unique list, i need to exctract all items in vertical list without #N/A and I prefer formula
Thank you so much

Hi

Try with a helper and a array formula
In I2 (helper column) use the following formula and copy down
=IFERROR(AGGREGATE(15,6,IF(--NOT(ISERROR($A$1:$E$10)),(ROW($A$1:$E$10)&"."&COLUMN($A$1:$E$10))+0,1/0),ROWS($A$1:$A1)),"")

In J2 use the formula and copy down

Formula:

Please Login or Register  to view this content.

Note: The red symbol must be the decimal separator.
See the file

Please try H2 and drag down

=IFERROR(INDIRECT("R"&REPLACE(TEXT(AGGREGATE(15,6,(ROW($A$1:$E$10)*100+COLUMN($A$1:$E$10))/NOT(ISERROR($A$1:$E$10)),ROWS(H$2:H2)),"0000"),3,,"C"),),"")

Thank you alla guys
Both formula works well, but I keep Bo_Ry because is not array formula and single formula, but onestly I'm studind this formula and i'm not undersatdig
I put solved
Thank you