I would like to manipulate data so that when rows are joined all rows are written to excel file, but only for the first row (based on the key cell) has values. To explain better
Product_ID;Inventory; sellUnits;
AAB;10;4;
AAB;0;3
AAB;0;2
CCA;15;4
CCA;0;3
DDA;1;1
My thinking is in kind of ways to sort data from excel, and then use some kind of when Product_ID changes, write inventory = 0.
ANy suggestion how to achieve this would be helpfull.