Hello,

I am working with data from two reports at work, one is MS Note Pad and the other is a company system report. I have imported the information from Note Pad into Excel.
The data I now have in Excel is the following;

Customer Purchase Order Number
Customer Name
My company’s part number
Quantity required for each Customer Purchase Order Number

My question is how do I sort this information so that I can see 1) the report sorted by part number from lowest to highest 2) see the customer name for each part number and the quantity 3) a total for that part number required on all orders.

I want the Excel report to look like this:

PO no. Customer Name Part Number Qty

16911955 SAFEWAY PORTLAND 0004142-015 9
16914908 SAFEWAY STOCKTON 0004142-015 14

23

Any help would be appreciated