Can you elaborate on the 'Goal' sheet layout ?

I can understand 1 line per IDNumber but am at a loss regarding the OrderID.
Why space for 3 ProductID's for first 2 OrderID's then only 1 ProductID for the third OrderID ?

Is there a Product limit per Order and an Order limit per IDNumber ?
If not, I'd suggest NOT having the order information split the consolidated information.

What was [quote]each buyer having anywhere from 1 to 9 product ids and 4 product types within each of those[quote] supposed to lead us to ?

Do you have this request posted on any other forums ?