Pivot Tables Question with Excel 2000
 

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.

Pivot Tables Question with Excel 2000
 

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.

Pivot Tables Question with Excel 2000
 

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.