Combine Rows For Duplicates in Column

[billgyrotech]

I have attached a down sized version of my workbook. The original workbook contains over 10K rows of data. I would like to be able to combine duplicates based on cells in column A from Table 1 to result in what is now Table 2. The cells in question are highlighted yellow in Table 1 which result in the rows highlighted green in Table 2. I appreciate any suggestions or help on this.

Thank you

[AliGW]

Here you go - try this:

Excel 2016 (Windows) 32 bit

	A	B	C	D
12	Table 2
13	ID	Paid	Due	Total
14	=IFERROR(INDEX($A$2:$A$9,MATCH(0,INDEX(COUNTIF($A$13:A13,$A$2:$A$9),0,0),0)),"")	=SUMIF($A$3:$A$9,$A14,B$3:B$9)	=SUMIF($A$3:$A$9,$A14,C$3:C$9)	=SUMIF($A$3:$A$9,$A14,D$3:D$9)

Sheet: Sheet1

[billgyrotech]

Oh my goodness that is a long reply.

[Pete_UK]

Here's a thread from yesterday, which covers the same subject:

http://www.excelforum.com/showthread.php?t=1167195

Hope this helps.

Pete

[AliGW]

No, I've edited it - I copied the wrong code initially!

[billgyrotech]

Wow you are really a wizard at this stuff thanks so much!

[AliGW]

You're welcome.