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.

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


If this post helps click Yes
--------------
Jacob Skaria


" wrote:

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.

Sorry here is the link

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

If this post helps click Yes
--------------
Jacob Skaria


" wrote:

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.