Hi Rick,

Don worry about the result column, we are not going to use that now.

Currently for example, 5 sentences are placed in column C. We need to unmerge and split the cells in column c and need to paste it in seperate lines below.

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 --> YES CORRECT.

The format will see same like my previous attachment.