I have a dataset where I need to make sure that each like ID gets assigned the same Value. It's not so much that I need to select a specific value to repeat from all that are assigned to the like ID, but that I need all the like IDs to have the same Value.
Data Have:
Id Value
101 656
101 756
101 805
101 752
501 999
502 405
502 365