filtre data

is there a simple solution (filter for example) to go from table 1 to 2. eliminate repetitive codes and calculate the quantity at the same time?