Assuming the same set-up as outlined in my earlier response, this should
help extract all the unique Comp - Cust from Sheet1 into Sheet2, i.e.
auto-produce the "master" table (I figure this is what you're after as well
?)

In Sheet1
------------
Using 2 empty cols to the right, say, cols O & P ?

Put in O2: =A2&"_"&B2
Put in P2: =IF(COUNTIF($O$2:O2,O2)>1,"",ROW())

Select O2:P2 and fill down to say, P2000
to cover the data in the table

In Sheet2
------------
Put in A2:

=IF(ISERROR(SMALL(Sheet1!$P:$P,ROWS($A$1:A1))),"",INDEX(Sheet1!A:A,MATCH(SMA
LL(Sheet1!$P:$P,ROWS($A$1:A1)),Sheet1!$P:$P,0)))

Copy A2 across to B2, fill down to B2000
(cover the same range as in Sheet1)

Based on the sample data in Sheet1, what you'll get in Sheet2's cols A and B
would be:

Comp Cust
ABC XXX
DEF YYY
(blank rows below)

Then just fill in the SUMPRODUCT formulas for the Prd#1 .. #10
into cols C to L, viz.

Put in C2:

=SUMPRODUCT((Sheet1!$A$2:$A$2000=$A2)*(Sheet1!$B$2:$B$2000=$B2),Sheet1!C$2:C
$2000)

Copy C2 across to L2, fill down to L2000*
[*or just fill down until the last row of data in cols A and B, to minimize
unnecessary calcs/recalcs. SUMPRODUCT does slow things down quite a bit. But
you have to remember to extend the formulas further down as may be required,
should you refresh the data in Sheet1 subsequently.]

Adapt to suit ...