I have two columns.

one contains two variables (John or Eddie)

the other contains a precentage per job relative to the painter (john or
Eddie).

What is the best way to get an average percentage for each of the painters.