Unduplicated names

Dear sir,with best regards,i have in attached file some details from my program,i need your help by a formula in (g) column to list all the unduplicated names which mentioned in (d) column.
Many thanks in advance.

Hi tofimoon4

G2:
=LOOKUP(REPT("Z",255),CHOOSE({1;2},"",INDEX($D$5:$D$33,MATCH(TRUE,INDEX(ISNA(MATCH($D$5:$D$33,$G$4:$G4,0)),0),0))))

fill down
it also help if you fill in your Location and MS version in your profile