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 th...