DSXchange

Thanks puliram!

Today i will try as per your suggestions and will let you know the results

actually my intention is to get the suggestion/solution for my questions and i am sorry for not following the proper format/practice and hereafter i will follow the good practices.

Thanks

sorry craig, it is my first post and i am not aware of the proper format to post here and hereafter it wont repeat

i/p ------ cola colb colc cold a 1 xx 12.50 a 2 xx 13.59 a 2 xx 14.50 a 2 yy 15.20 b 1 xx 13.20 b 2 xx 12.00 b 3 xx 13.00 b 3 zz 14.00 o/p ------ cola colc 1 2 3 a xx 12.50 28.09 0.00 a yy 0.00 15.20 0.00 b xx 13.20 12.00 13.00 b zz 0.00 0.00 14.00