duplicate entries after table query merge

Hello!

I'm looking for a bit of help here. I'm newer to data merging and I'm running into a particular problem!  I'm importing the data from Excel (2 tables) and there was no unique identifier with no duplicates between them, so I created a join column so that they could be merged through a left outer. It worked! BUT- in each table there is a column for 'score'. Table 2 has multiple entries for errors (line items) related to a single data point in Table 1. So, the issue is post-merge is that the score is pulled in and counted for each error or line item where I only need 1 instance of the score so that I can average the values correctly. 

I have an example here.

The left visual shows an un-merged dataset and therefore what the actual average of score should be. The one on the right shows what I am dealing with post-merge. I've included COUNT of the score to show the issue. The data has to be sorted by Language, 

Any help is greatly appreciated!!