Make a Unique List from data table

I have a data table.
I want to get the unique names from data table to a new table according to ID number.

I need only a formula, NOT pivot table and MACRO.

in the attached file all explanations exist.

Thanks in advance for prompt answers.

Regards,