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

@Truir 

Try creating a pivot table based on the data.