copy name from list to other cell without repeat and sum value corresponding to this name

[mazan2010]

Hello All
i need formula in Column AL , Am and AN that will do the following function
in AL column will collect all name from column A with repeat
in Am column will sum all data from column G that corresponding for Name
In AN will sum all data from column AG that corresponding for Name

[mazan2010]

I found some formula but not working well you can see in my new attached file IN COLUMN AL AND AM

[JohnTopley]

Won't work with merged cells!!!

[mazan2010]

And what the solution because as you can see in my attached file each name have some row for data

[JohnTopley]

Unmerge cells in column A

then use this to get your list of names in AL

=IFERROR(INDEX($A$2:$A$100,MATCH(0,IF(ISBLANK($A$2:$A$100),1,COUNTIF(AL1:$AL$1,$A$2:$A$100)),0)),"")

Enter with Ctrl+Shift+Enter

To SUM values look at SUMIF / SUMIFS functions.