I want to merge cells in both direction based on cell value like below example.
In Col2, row1 & row2 can be merged only if Col1 value is same. I tried to do this using mergeCellInfo event. Am able to merge row1 & row1 for Col1. AM not able to add the row3 to the already merged cell. What is the right approach to do this ?