Finding an average of cells with an Id

Hi All Could anyone give advice on finding the average of a set of numbers linked to a cell ID I would like it displayed as below  I have calculated this manually but I have a ton of d...