VBA loop through table combine like columns and add and concatenate respective cell

Hey guys,

I need to combine two separate rows that have the same account number (Column A) and sum up the QTY column(G) but the kicker is that I need the Person column(I) to be concatenate if multiple persons exist. I need to loop through a dynamic table ie the table will change in size. See attached as an example.

Orignal Table:
acct_no TYPE Description PM maturity_date position_ind Qty comp_sec_type_code Person
100 Apple Red xx 9/20/2012 L 2453 Pack Jack
100 Apple Red xx 9/20/2012 L 4534 Pack Jill

New Table:

acct_no TYPE Description PM maturity_date position_ind Qty comp_sec_type_code Person
100 Apple Red xx 9/20/2012 L 6987 Pack Jack, Jill

Thank you for your help!!!!!