In A1:A1000 I have cells with text and blank cells. Texts are often
repeated.

I would like in B1:B1000 all texts appearing at the top, without any
duplicates, blanl at the bottom.

What formula should I use in B1:B1000 ?

Thank you

A B
1 ABC ABC
2 XYZ XYZ
3 GHT GHT
4 GHT
5

Is it possible that B1:B1000 appear already sorted?