I have the following problem. I have the following data I want to copy an entire row in the different sheet with different type of data. some data fields are merged as well.
So i find it difficult to convert in the required format
for example i have the data as
<tbody>
1CO1
1CO2
1CO3
1CG1...