Best Way to do this?

I am working on a Data project and am a bit stuck.

I am trying to combine the JP_sales information together with other rows that share the same name.

Processing by hand would be quite tedious as there a hundreds in the dataset.

Any ideas would be absolutely amazing