Help sorting data into chart...


I have a table which records serial numbers of parts and the number of hours they have been tested for. I need to create a chart showing how many hours each serial number has been tested for. Here is the table:

SSPC 1 & 2 are the same parts, can be used in either slot 1 or 2. I need to count the total number of vibe minutes and ESS hours for each serial number.

Thanks 😊