I'm trying to consolidate crypto data from BscScan, by ID (a Hash in this case). As the downloaded data has many irrelevant columns, and actual hash data is very long, I've created a simple abbreviated data example of what I'm trying to do:

For each Hash, I need to

1. Sum the "Number" column
2. Count the Number of Records

Some pointers on how to do this would be appreciated.

CodePudding user response：

Please try this