On Jul 16, 5:18*pm, AG wrote:
Hi dk, Yes I get this data on an excel sheet.

I would suggest you following algo:

1. Get the last data cell in the worksheet.
2. Loop untill you reach the last data cell
3. Read each row and check if it has 'title' in there.
4. If yes read the title1 and title2 into two variables.
5. Write into the new sheet the titles and then the data record.
6. Repeat the step 5 untill you come across next title1 and title2.
7. Update the variables with new title1 and title2. Repeat steps 5 to
7.
8. At the end of this, you may delete the old worksheet.

Hope it helps
-DK