BASIC QUESTION | Last String data like lookup

[Kakokkeska]

Hello, I hope you well 

I have a union table with peaple data and in these tables have differents data for the same person. I need to get the last  information in X column in another column. I tried to use Lookup but return an error because have duplicated IDs, how I can do it?

Bellow an example, the division was changed in any moment but I would like a column that all division for this ID is the same, could be possible?