There can be maximum of 20 allocation per comm id and how can I do pivot on multiple columns.

Thanks for the reply !!

But there can be thousand of Comid , is there any other way to to do this...

Thanks a lot for replying!!!!