Quote Originally Posted by san.rathinapuri View Post
ALWAYS THERE WILL BE 4 CELLS MERGED.ITS NOT DEPENDS UPON THE NUMBER OF STEPS AND PRE-REQUISITE.

NO OUTPUT SHOULD GO THERE TO RESULT COLUMN.
JUST WE WANT TO SPLIT THE CONTENT FROM COLUMN C (FOR EXAMPLE) TO BELOW CELLS.
Your posted workbook showed the result in the data column and it split the result into separate cells there (that is, it unmerged the merged cell). Are you now saying you want to keep the data cell as is and put the split out result in the Result column? Also, in order to put them into separate cells when the data is split and there are more than 4 split out rows, additional rows would need to be added to accommodate them... you do understand this, correct?