UNIX for Dummies Questions & Answers

Hello everybody. I am new here and hoping someone is willing to help. I just want to know if anyone can tell me how it would be possible to combine two separate rows in excel while adding certain pieces of information and keeping others the same.

Here is what I mean. I want to combine the same products into one row. While keeping the product number and per unit price the same while adding the quantity's together and updating the total cost. Also if possible indicate the number of different customers for the customer column.

Code:

  Customer .Product .Product Number.Quantity. Per Unit Price.Total  
   Bonnie / Clamp / 4216 / 13 / 5    =PRODUCT(D23,E23)   
   Bonnie  / TB / 1356  / 5  / 20  /  =PRODUCT(D26,E26)   
   Shawn /  Washers / 3212 / 15  /   0.2 /  =PRODUCT(D29,E29)   
   Bonnie  /  Washers / 3212 / 10 / 0.2 /  =PRODUCT(D30,E30)

So that this will look like...

Code:

  Bonnie /  Clamp /   4216 / 13 /  5 / =PRODUCT(D23,E23)   
  Bonnie / TB /  1356/. 5 / 20 / =PRODUCT(D26,E26)   
  2 / Washers / 3212 / 25 / 0.2  / =NEW PRoduct

Thanks a lot and any and all help will be greatly appreciated!

Moderator's Comments:

Please use next time code tags for your code and data

Dont know xl but dumping it as a csv file...ftping it to a unix box...followed by awk processing...uploading it back to the source machine...then opening it in xl can give you what you want althogh it does require all those extra steps