How to make header to a particular row

I have a datatable ,there is some keyword in between of the datable. I if that keyword is is found i want to make that whole row as a header. And also these keyword is merged so the merged rows should also become a header.

Like for example my keyword is present in row 15 but the row is merged with row16.
So both rows 15 and 16 should make as a header.

Please helpp

Hi @Tabbu ,

Dealing with the Merged Rows or generating table with merged rows could not be so easy. We would have to use Excel Application Scope or External Custom Activities for Merging of the Rows.

However, Could you Provide us Sample Input and the Expected Output File/Screenshots in order for us to assess what would be required to obtain a solution.