Excel Data Consolidation

[ialwayscapital]

I am working on a salary sheet and stuck on this situation.
Sheet has a to z columns with these headings.

What i need is, if employee name and employee code repeat several times, then i get sum of his duty, wages, pf, esi, pt, gross salary, advance, uniform, add money, take home, bank cheque, bank cash & cash in hand in ANOTHER WORKSHEET.
For example,
Pooja Yadav, 25 (duty), 9750 (wages), 650 (pf), 300 (esi), 160 (pt), 8640 (gross salary), 4000 (advance), blank (uniform), blank (add money), 4640 (take home), 3820 (bank cheque), blank (cash in hand.
Things written in brackets are just for understanding sake (consider it as column heading)

Please help me out, Thanks

 

[ialwayscapital]

Thanks for all the help @Sam_D_Ben

Since my query is solved now with the help of various forums and self experiments. Its my duty to post solution as well. Here is the solution.


First of all, Make one helper column, Say F used as helper.
Formula for F2 is =C2&" "&D2&" "&E2&", "
Above formula joins text of C2, D2 & E2




Formula for H2 is =IFERROR(INDEX($B$2:$B$11,MATCH(0,COUNTIF($H$1:H1,$B$2:$B$11),0)),"")
Above one is Array formula requires Ctrl + Shift + Enter to enter the formula
Now, coloumn H has unique values from list B2:B11




Formula for I2 is =INDEX($A$2:$A$11,MATCH(MAX(IF($B$2:$B$11=$H2,$E$2:$E$11)),IF($B$2:$B$11=$H2,$E$2:$E$11),0))
Above one is Array formula requires Ctrl + Shift + Enter to enter the formula
This formula shows the area code where highest duties performed, If duties are same for some particular person then it shows the first one found.
Thanks to this Post for greater help.




Formula for J2 is =SUMIF(B2:B11,$H2,E2:E11)


Formula for K2 is =TEXTJOIN(CHAR(10),,IF(($B$2:$B$11=H2)*($F$2:$F$11<>"")=1,$F$2:$F$11,""))
Above one is Array formula requires Ctrl + Shift + Enter to enter the formula

Thank You