I have an excel sheet that has 6000 lines. There are about 100 different customers with multiple lines for one customer. Each line is a single unit.

Customer number Customer name Type of unit1
Customer number Customer name Type of unit1
Customer number Customer name Type of unit2
Customer number5 Customer name5 Type of unit1
Customer number5 Customer name5 Type of unit2
Customer number5 Customer name5 Type of unit2


Is there a way to get a total unit count for each customer but only have it show up on one line per customer?

Customer number Customer name Type of Unit1 Total count 3
Customer number Customer name Type of Unit1
Customer number Customer name Type of Unit2
Customer number5 Customer name5 Type of unit1 Total count 3
Customer number5 Customer name5 Type of unit2
Customer number5 Customer name5 Type of unit2


If possible, is there a way to get a total unit count for each different type of unit per customer but only have it show up on two lines per customer?

Customer number Customer name Type of Unit1 Resulting in: Customer Number or Name Total count Unit1 2
Customer number Customer name Type of Unit1 Customer Number or Name Total count Unit2 1
Customer number Customer name Type of Unit2
Customer number5 Customer name5 Type of unit1 Customer Number or Name5 Total count unit1 1
Customer number5 Customer name5 Type of unit2 Customer Number or Name5 Total count unit2 2
Customer number5 Customer name5 Type of unit2


I don't know much about excel, yet, so I am hoping this is even possible to do so I don't have to filter through 6000 lines and count each unit for each customer we have.