Find the Mode of Row Values Based on ID Column (Favorite Fruits)

Hello all,   I am trying to find a way to determine everyone's favorite fruit. This is the table that I have: ID          Name       Fruit Eaten 1 Joe Banana 1 Joe Banana 1 Joe Ora...