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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Customer 1[/TD]
[TD]Banana[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Customer 1[/TD]
[TD]Banana[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Customer 1[/TD]
[TD]Apple[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Customer 2[/TD]
[TD]Banana [/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Customer 1[/TD]
[TD]Banana [/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Customer 1[/TD]
[TD]Banana [/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

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!