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
<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!![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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!