Nothing to be afraid of... they are really quite easy...

On the sheet with your source data select Data - Pivot Table...
When the wizard opens just choose finish (99.9% of the time XL will guess
correctly)
A new sheet will open with a pivot table and a field list
Drag the Value to the center data area
Drag the Unique Id to the Left hand column.
Drag the Type to the left hand column.

Each of the fields on the pivot table can be dragged anywhere else in the
table that you want... That's the basics.
--
HTH...

Jim Thomlinson


"MeatLightning" wrote:

Ah, yes... the Pivot Table... they scare the me sweaty. Um, I guess if I'm
totally S.O.L. I'll take another look?