Dear All, I am new to this forum. I have requirement in excel can any one help me out.

data base contains zsm,distributor name and sales value which will be shared by every zsm and it will be collated in single
sheet, Based on the data script needs to prepared to send SMS.

Data Base
ZSM Distributor Value
alagar Ramesh 100
Baskar abc 100
Baskar def 200
Baskar ktz 400
raja sddc 500
ramu ghi 300
ranga jhdj 600
ramesh dd 700

Requried Output:
ZSM Script
alagar alagar(Ramesh,100)
Baskar Baskar(abc,100),(def,200),(ktz,400)
raja raja(sddc,500)
ramu ramu(ghi,300)
ranga ranga(jhdj,600)
ramesh ramesh(dd,700)