Change value for multiple cells in Excel

If I have an Excel sheet with lets say 2 columns Name | Age, and in the Name column I have some 2000 entries and some of them repeat more than once in a random order, how can I populate the Age column inserting the value only once for each unique rec开发者_运维百科ord from the Name column?

Excel noobie, so sorry if the question seems stupid.

Thanks!

---

Solved with pivot tables and VLOOKUP!

---

One solution could be to use the advanced filter to copy unique values.
Alternatively you could use a countif() to identify the duplicates.
Sorting by name could also be of help.