Data sorting and calculation

[Raza2010]

Hello there, Can anyone please help me with this as I'm starting to pull my hair out looking for a solution. I thought about using a Pivot-table but I'm either doing it wrong or it's not suitable for my needs.
Basically I'm trying to sort the following data.

In list 'A' I have data which I would like sorted and displayed as in list 'B'

LIST 'A'

Code Name Qty Box's
1234 Name1 231 2
6789 Name2 212 1
1234 Name1 522 3
1234 Name1 212 2


LIST 'B'
Code Name Qty Box's
1234 Name1 965 7
6789 Name2 212 1

The actual data I'm working with is on a bigger scale but I hope I've got across my question.
Please Help

Kind Regards,

Pete.

 

[diddi]

are the Code values all numeric?

 

[Raza2010]

Hi

Yes the code values will always be numeric

Rgds.