Difficult Transposing Issue

The File
I have a list of clients and their services that I need to transpose from rows to columns. This one is a little more tricky, so I can't use "paste special > transpose".

The Problem
The clients and their services are listed separately in rows:

Cust # price
55551 $100
55552 $50
55552 $25
55553 $200
55554 $35
55555 $655
55555 $51
55555 $894
55555 $156

but I need the spreadsheet to say:

Cust # price1 price 2 price 3 price 4
55551 $100
55552 $50 $25
55553 $200
55554 $35
55555 $655 $51 $894 $156


My Idea
Important: Open attachment first.

This is the logic I have in mind for the formula, but I don't know how to build it. It is NOT an exact formula whatsoever:

insert into E2
IF D2 matches any cell in A:A, then (If adjacent B cell has the number 1 in it) copy adjacent C cell into E2, if not then ""

insert into F2
IF D2 matches any cell in A:A, then (If adjacent B cell has the number 2 in it) copy adjacent C cell into F2, if not then ""

insert into G2
IF D2 matches any cell in A:A, then (If adjacent B cell has the number 3 in it) copy adjacent C cell into G2, if not then ""

insert into H2
IF D2 matches any cell in A:A, then (If adjacent B cell has the number 4 in it) copy adjacent C cell into H2, if not then ""

insert into I2
IF D2 matches any cell in A:A, then (If adjacent B cell has the number 5 in it) copy adjacent C cell into I2, if not then ""

insert into J2
IF D2 matches any cell in A:A, then (If adjacent B cell has the number 6 in it) copy adjacent C cell into J2, if not then ""

A = Customer Number
B = Duplicate Sequence #
C = Price
D = Unduplicated Customer #
E = Price 1
F = Price 2
G = Price 3
H = Price 4
I = Price 5
J = Price 6

Further Explaination
Column A displays the customer number

55551
55552
55552
55553
55554
55555
55555
55555
55555

Column B displays the sequence of the customer duplicate:

1
1
2 (2nd time the customer number is listed)
1
1
1
2
3
4

If you can think of a better way to accomplish this, then sweet! One could say, "Why don't you just manually do this?" Well, that's because this is over 5,000 customers, and more than 6 prices.

No VBA please.

Thanks!