Hi,
I have a spreadsheet which contains data as follows and I need it to be compressed. For example my data is as follows;
Product | Quantity
Apples 100
Apples 50
Apples 20
Bananas 200
Bananas 150
Bananas 50
Bananas 10
Carrots 300
Carrots 200
I need the data to be compressed to;
Apples 170
Bananas 410
Carrots 500
Any help is much appreciated
Tahir
Bookmarks