If you transpose the data and group by the ID column, you can then use a summarize tool and group by the ID and get the Mode from the value field. Next you'll join back to your original data (deselect the right_ID) using is as the key and you'll have solved your challenge.
Cheers,
Mark
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please
Subscribe to my youTube channel.