Extract names from list only once

Hello forum.
I have in a column, a list (B10:B1000) of names and empty cells, but the names are repeated several times.
How can i have a new list, with all the names of the existing list, but only once each of names?
ie. If in existing list we have the name John 10 times, in a new list i want to have only once the name John.
Thanks in advance.

Thanks for your suggestion but this list always updated with new or same names. I think that doesnt works well.

If you would prefer a formula approach, perhaps you can try something like this:

D2 =IFERROR(INDEX(B$1:B$1000,MATCH(0,COUNTIF(D$1:D1,B$1:B$1000),0)),"") Ctrl Shift Enter

Edit: This one will handle blank cells:
D2 =IFERROR(INDEX(B$1:B$1000,MATCH(0,IF(ISBLANK(B$1:B$1000),"",INDEX(COUNTIF(D$1:D1,B$1:B$1000),0,0)),0)),"") Ctrl Shift Enter

Thank you very much falcon it works! But, why the second result is zero? I didnt have zeros in my list.

Originally Posted by 63falcondude

....
Edit: This one will handle blank cells:
D2 =IFERROR(INDEX(B$1:B$1000,MATCH(0,IF(ISBLANK(B$1:B$1000),"",INDEX(COUNTIF(D$1:D1,B$1:B$1000),0,0)),0)),"") Ctrl Shift Enter

Ok falcon this works better, removes the zero! Than you again for your help! I really appreciate it!