Best Way to do this?

Copper Contributor

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


Screenshot 2023-09-06 142424.png


1 Reply


Try creating a pivot table based on the data.