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 data to average

Many Thanks