Multiple column Balance Summarization

[casexcel]

I have over 6000 rows of data. I have sorted it so each person has 2 lines of data that need to be added together. Each cust has 2 rows of data that need to be combined, but I need it to return the information in each column

Row 1 (Col A - D) = Headers

A Cust No B Name C Type D Balance

1000 Jane Doe Silver $10.15
1000 Jane Doe Silver $599.07
2000 Jim Smith Gold $130.05
2000 Jim Smith Gold $379.34
3000 Joe Go Platinum $37.95
3000 Joe Go Platinum $397.03

I need the end result to look like:

A Cust No B Name C Type D Balance

1000 Jane Doe Silver $609.22
2000 Jim Smith Gold $509.39
3000 Joe Go Platinum $434.39

I can't get the consolidate to work and bring back all the original information.

What is the easiest way to do this?
Catherine

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D	E	F	G	H
1	Cust No	Name	Type	Balance
2	1000	Jane doe	Silver	10.15		1000	Jane doe	609.22
3	1000	Jane doe	Silver	599.07		2000	Jim Smith	509.39
4	2000	Jim Smith	Gold	130.05		3000	Joe Go	434.98
5	2000	Jim Smith	Gold	379.34
6	3000	Joe Go	Platinum	37.95
7	3000	Joe Go	Platinum	397.03
Output

Cell Formulas
Range	Formula
G2	=INDEX(B$2:B7,MATCH($F2,$A$2:$A$7,0))
H2	=SUMPRODUCT(--($A$2:$A$7=$F2),($D$2:$D$7))
F2	{=INDEX(A$2:A$7,MATCH(0,COUNTIF(F$1:F1,A$2:A$7),0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[sandy666]

another way:

with PivotTable or PowerQuery

Column1	Column2	Column3	Column4		PivotTable
1000​	Jane Doe	Silver	10.15​		Column1	Column2	Column3	Sum of Column4
1000​	Jane Doe	Silver	599.07​		1000​	Jane Doe	Silver	609.22​
2000​	Jim Smith	Gold	130.05​		2000​	Jim Smith	Gold	509.39​
2000​	Jim Smith	Gold	379.34​		3000​	Joe Go	Platinum	434.98​
3000​	Joe Go	Platinum	37.95​		Grand Total			1553.59​
3000​	Joe Go	Platinum	397.03​
					PowerQuery
					Column1	Column2	Column3	Sum
					1000​	Jane Doe	Silver	609.22​
					2000​	Jim Smith	Gold	509.39​
					3000​	Joe Go	Platinum	434.98​

i forgot about headers but this is cosmetic issue