How to get rid off duplicate items?

Hello!

I attached a xls file showing start and end of the project.

As you can see in END sheet there is no duplicate values in first column.
Can I do it without help of pivot (or manually deleting every duplicate )?

Thanks a lot!