123456789
Dog
100
123456789
Cat
10
123998765
Dog
10
123998765
Cat
50
123998765
Hamster
100
add all sales
per ID field
Sort per unique
ID, highest value
on top
Column A - Ascending
Column C - Descending
First
1
take first record
per ID field
First 1
Join sales
in by ID
Horizontal
MergeDupes+transform