1. Select a single cell within the table of your data.
2. From the "INSERT" tab, select "PivotTable." This should be on the far left.
3. The "Create PivotTable" dialog box should appear & the entire range of your data should be selected.
4. Check to make sure "New Worksheet" is seledcted.
5. Select "OK"

You should now have a new worksheet with a blank PivotTable and a PivotTable Field List window open on the right of your screen.

1. Drag your "Part Number" Field to the "Report Filter" Window.
2. Drag all the relevant data fields of interest to the window labeled "Row Fields"

Also notice that there is two new tabs that appear in the Ribbon under PivotTable Tools that can be used to format the PivotTable.

Under the "Design" Tab, I like turning Subtotals Off, Grand Totals Off, & under Report Layout choose "Show in Tabular form"

That should get you started

Hope I helped
__________________
__/|\__ Excel 2007 & WinXP