Question: If I have excel table looks like this

```
ID  Description id1 id2 id3 id4
1   test        3           
1   test            4       
1   test                5   
1   test                    6

```

And I want to know a way to combine the all these 4 record become this one

```
ID|Description|id1|id2|id3|id4
1  test        3   4   5   6

```

How can I do that in Excel?

Answer: 
I ended up using this solution from [PF forum](http://forum.primefaces.org/viewtopic.php?f=3&t=26813#p93374): 

```
<p:contextMenu for="ratingScaleTable" id="RsContextMenuId"  widgetVar="ctxMenu" beforeShow="return true;">

<p:dataTable id="ratingScaleTable" widgetVar="tableWidget"
...
  <p:ajax event="rowSelect" process="ratingScaleTable" listener="#{ratingScaleBK.edit}"  update=":templateForm:tabView, :templateForm:dirtyFlag, :templateForm:tabView:RsContextMenuId" />
  <p:ajax event="contextMenu" update=":templateForm:tabView:RsContextMenuId" oncomplete="ctxMenu.show(currentEvent);"/>

```

and the associated JavaScript:

```
<script type="text/javascript">
var currentEvent;
  $(document).ready(function() {
  PrimeFaces.widget.ContextMenu.prototype.show = function(e) {
     //hide other contextmenus if any
     $(document.body).children('.ui-contextmenu:visible').hide();

     if(e) {
        currentEvent = e;
     } 

     var win = $(window),
     left = e.pageX,
     top = e.pageY,
     width = this.jq.outerWidth(),
     height = this.jq.outerHeight();

     //collision detection for window boundaries
     if((left + width) > (win.width())+ win.scrollLeft()) {
        left = left - width;
     }
     if((top + height ) > (win.height() + win.scrollTop())) {
        top = top - height;
     }

     if(this.cfg.beforeShow) {
        this.cfg.beforeShow.call(this);
     }

     this.jq.css({
        'left': left,
        'top': top,
        'z-index': ++PrimeFaces.zindex
     }).show();

     e.preventDefault(); 
  };
});
</script>

```
Try it with the *contextMenu* event:

```
<p:contextMenu for="ratingScaleTable" id="RsContextMenuId" widgetVar="ctxMenu">
    ...
</p:contextMenu>

<p:dataTable ... > 
    ...
    <p:ajax event="contextMenu" process="ratingScaleTable" listener="#{ratingScaleBK.edit}"  update=":templateForm:tabView, :templateForm:dirtyFlag, :templateForm:tabView:RsContextMenuId" oncomplete="PF('ctxMenu').show();" />
    ...
</p:dataTable>

```