How to merge duplicate columns and sum value

[stan255]

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!

[loginjmor]

Hi -

The simplest is to use a pivot table. That will collapse your data a sum on Price.

Hope that helps.

[stan255]

Thanks loginjmor for that solution. That worked.
+rep