You dragged the header for the prodtype to the Row field.

You can fix it by going back to the wizard
(rightclick anywhere in the pivottable and select wizard)

Then drag the header for the ProdType to the Column field

Or you can just drag the header for that prodtype to the cell directly to its
right (same row). Right on top of the Total cell.

hywel wrote:

Thanks, Dave, but the numbers are in 3 separate columns - so job 1234
has got 6 of Prod 6 and 7 of Prod B.
Your solution produces:

1234,Sum of Prod A,6
<Blank,Sum of Prod B,7
<Blank, Sum of Prod C,<Blank

Whereas I looking to show only non-zero values and the job on each
line, like this:

1234,Sum of Prod A,6
1234,Sum of Prod B,7

It's nearly there!

Hywel

Dave Peterson wrote in message ...
Are all those things in the third column numbers? If yes, then...

This looks like a job for....Data|Pivottable

Add a single row of headers to your data (if you don't have them now).
select your data A1:C9999 (through the bottom right corner)
Data|pivottable (actually, this menu item changes captions with versions of xl)
follow the wizard
(just click Next until you get to a dialog that has a Layout button on it)
click that Layout button
Drag the header for the Job to the Row field.
drag the header for the ProdType to the Column field
drag the header for the Qty field to the data field

If you see "Count of qty" then double click on that one and
change it to Sum (sum of qty)

click ok and finish

Tada!


--

Dave Peterson