Remove the duplicate and add the amount column

@Sikander_siki
Welcome to the forum

We can do this with grouping the data