Obrain Unique Values from Two Columns

[Manojlo]

Hello,
I have two list in column A and B, I would like to have unique list of values in column C, from column A and B, like is on the example.

 

[Takae]

Please try this formula.
=UNIQUE(FILTERXML("<a><b>"&TEXTJOIN("</b><b>",,A2:A14,B2:B14)&"</b></a>","//b"))

 

[Peter_SSs]

If you happen to have the VSTACK function then there is also the possibility of using the formula structure I used in this post in your other thread.

In that other thread the columns to make the unique list from were not adjacent but if they are adjacent like your sample above, and you don't have VSTACK, then you can also combine the ranges in the formula suggested above by @Takae

=UNIQUE(FILTERXML("<a><b>"&TEXTJOIN("</b><b>",,A2:B14)&"</b></a>","//b"))

 

[Manojlo]

Please try this formula.
=UNIQUE(FILTERXML("<a><b>"&TEXTJOIN("</b><b>",,A2:A14,B2:B14)&"</b></a>","//b"))

This works, Thank you

 

[Manojlo]

If you happen to have the VSTACK function then there is also the possibility of using the formula structure I used in this post in your other thread.

In that other thread the columns to make the unique list from were not adjacent but if they are adjacent like your sample above, and you don't have VSTACK, then you can also combine the ranges in the formula suggested above by @Takae

=UNIQUE(FILTERXML("<a><b>"&TEXTJOIN("</b><b>",,A2:B14)&"</b></a>","//b"))

This works, Thank you

Please try this formula.
=UNIQUE(FILTERXML("<a><b>"&TEXTJOIN("</b><b>",,A2:A14,B2:B14)&"</b></a>","//b"))

This works, Thank you