Thread: Data summarizing!?

I use a software that generates reports in excel(These reports fill up Columns ("A:DG"). I have to clean up the reports every month and submit them. I am trying to make this process quicker.

So I created a application that when activated removes all unwanted columns and sorts the corrects columns by either a Part number or a vendor (via userforum).

I want to be able to summarize the information by the part number.

So in Column ("A") I have a many of the same part number and in Column( "B") I have the quantity of that part number. Looks like this

Part Number---------Quantity
AAA123--------------------10
AAA123--------------------25
AAA123--------------------40
AAA123--------------------30
AAA123--------------------20
AAA123--------------------75
BBB345--------------------10
BBB345--------------------25
BBB345--------------------40
BBB345--------------------30
BBB345--------------------20
BBB345--------------------75


I want it to look like this:

AAA123--------------------200
BBB345--------------------200



The generated report can have anywhere from 1-10,000 parts... Any help??

I suspect a Pivot Table is the simplest solution.


Regards

Search the forum, there will be many examples

See the attached example.

In Excel 2007:
select any cell in the data area
select in the Insert tab/ribbon
select the Pivot Table icon ... on the very left
confirm the range and decide where you want the pivot table
(in this case, I put it on the same sheet - cell Sheet1!$E$3
Put Part Number in Row labels and Quantity in Values
Close the dialogue box (x in the top right corner)

Done

Regards

If your problem has been solved please mark it as such.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Thank you

You're welcome. Thanks for the rep.

If this has answered your question, please mark your thread as solved. See previous post.

Regards