Excel VBA consolidate duplicate rows in to "blocks"

[Pelle]

Hi,

I have a large number of duplicate rows that I would like to merge/consolidate into blocks of 10 and rename the product.

Here is some sample data: Customer, product, qty

Customer 1	Banana	1
Customer 1	Banana	1
Customer 1	Apple	1
Customer 2	Banana	1
Customer 1	Banana	1
Customer 1	Banana	1

<tbody>
</tbody>

Desired Result: If the number of bananas is up 10 for customer 1, consolidate into 1 row and rename to FruitbasketA (1-10 bananas). If the number of bananas is up to 20 consolidate into two rows, fruitbasketA (1-10) and fruitbasketB (11-20). 15 Bananas would give 2 baskets.

Maximum number I need to handle is 60 bananas divided into baskets like this.

Thank you four your help!