Need Aggregrated values like below output from input

[#1]

Hi

I have given input and output below I need the desired output Please help me out in this

1st table is input data  we need  to get 2nd table......( I gave agent A but list goes on........... )

[MK_QSL]

Can you provide criteria/logic behind the output table?