I am using Excel 2000 with a spreadsheet.

The spreadsheet has hundreds of lines of data, similar to this:

part#, part description, dept1, dept2, dept3

Each part# shows up multiple times on the worksheet.

How do I create a pivot table that maintains these headers, but only
has one total for each part#?
part#, part description, dept1, dept2, dept3

Can I do this with a pivot table?

Thank you in advance for your help.