The actual data is below:
<tbody>
</tbody><colgroup><col><col span="6"></colgroup>
the End Result should be like:
<tbody>
</tbody><colgroup><col><col span="6"></colgroup>
S. No | First Name | Last Name | Gen ID | Band | Start Date | End Date |
1 | Aaron | Small | 33371 | S1 | 20-01-2017 | 14-12-2017 |
2 | Abdul | Karenina | 33372 | S2 | 25-10-2017 | 28-11-2017 |
3 | Abe | Sarandon | 33373 | S3 | 18-05-2017 | 20-07-2017 |
4 | Abraham | D'Arby | 33375 | S5 | 15-03-2017 | 20-05-2017 |
5 | Abram | Palyuvchenko | 33376 | S6 | 08-01-2017 | 09-01-2017 |
6 | sarftyu | Sarandon | 33373 | S3 | 21-05-2017 | 20-07-2017 |
<tbody>
</tbody><colgroup><col><col span="6"></colgroup>
the End Result should be like:
S. No | First Name | Last Name | Gen ID | Band | Start Date | End Date |
1 | Aaron | Small | 33371 | S1 | 20-01-2017 | 31-01-2017 |
1 | Aaron | Small | 33371 | S1 | 01-02-2017 | 28-02-2017 |
1 | Aaron | Small | 33371 | S1 | 01-03-2017 | 31-03-2017 |
1 | Aaron | Small | 33371 | S1 | 01-04-2017 | 30-04-2017 |
1 | Aaron | Small | 33371 | S1 | 01-05-2017 | 31-05-2017 |
1 | Aaron | Small | 33371 | S1 | 01-06-2017 | 30-06-2017 |
1 | Aaron | Small | 33371 | S1 | 01-07-2017 | 31-07-2017 |
1 | Aaron | Small | 33371 | S1 | 01-08-2017 | 31-08-2017 |
1 | Aaron | Small | 33371 | S1 | 01-09-2017 | 30-09-2017 |
1 | Aaron | Small | 33371 | S1 | 01-10-2017 | 31-10-2017 |
1 | Aaron | Small | 33371 | S1 | 01-11-2017 | 30-11-2017 |
1 | Aaron | Small | 33371 | S1 | 01-12-2017 | 14-12-2017 |
2 | Abdul | Karenina | 33372 | S2 | 25-10-2017 | 28-11-2017 |
2 | Abdul | Karenina | 33372 | S2 | 25-10-2017 | 31-10-2017 |
2 | Abdul | Karenina | 33372 | S2 | 01-11-2017 | 28-11-2017 |
<tbody>
</tbody><colgroup><col><col span="6"></colgroup>