Pivot Tables Question with Excel 2000

[tonyrulesyall]

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.

 

[Jacob Skaria]

Watch this interesting video tutorials and more materials on Pivot table.


If this post helps click Yes

 

[Jacob Skaria]

Sorry here is the link

http://www.ozgrid.com/Excel/excel-pivot-tables.htm

If this post helps click Yes