excel-question-1.png

What I'm trying to achieve here is:
1. Merge the duplicate customer code and customer name together
2. Sum up the price
3. Output the correct account manager for the company

Final output will look like this
excel-question-2.png

Anyone knows how to do this? Any help will be greatly appreciated!