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.