Spreadsheet: 861517d1709397015-how-to-transform-horizontal-data-with-merged-headers-to-a-vertical-format-sample-w-pq
Sheet: Sheet1

 | Emplyee [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Father [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Child - 1 |  |  |  | Child - 2 |  |  |  | Child - 3 |  |  |  | Child - 4 |  |  |  | Child - 5 |  |  |  | Child - 6
Date | CNIC No. | Email address | Employee Code |  |  |  | Name of Employee | Department | Date of Joning  DD-MM-YYYY | Date of Birth | Gender | Employee Age | Address | [NAME] | Name | CNIC | Date Of Birth2 | Age | Name3 | CNIC4 | Date Of Birth5 | [NAME] | Name7 | CNIC8 | Date Of Birth9 | Age10 | Name11 | Date Of Birth12 | Gender13 | Age14 | Name15 | Date Of Birth16 | Gender17 | Age18 | Name19 | Date Of Birth20 | Gender21 | Age22 | Name23 | Date Of Birth24 | Gender25 | Age26 | Name27 | Date Of Birth28 | Gender29 | Age30 | Name31 | Date Of Birth32 | Gender33 | Age34 | Present Salary | Contact Number
 | 123 | AAA | 100 |  |  |  | ABC | Marketing | 2017-10-10 00:00:00 | 1990-01-13 00:00:00 | FEMALE | 33 | Flat#123 | Married | ADDDD | 111 |  | 61 | GHI | 222 |  | 60 | JB | 203 | 1990-01-13 00:00:00 | 30 | HGAA |  | Male | 5 | PHAI |  |  | 2
 | 111 | BBB | 103 |  |  |  | CCD | Prod | 2022-06-01 00:00:00 | 1986-04-09 00:00:00 | MALE | 36 | Flat#124 | Married | ABGGG | 11111 |  | 65 |  |  |  |  | BH | 1011 | 1990-01-13 00:00:00 | 30 | VGG |  | Male | 4 | ABGH |  |  | 2 | HVVV |  |  | 1
 | 201 | CCC | 101 |  |  |  | GHT | Export | 2017-02-01 00:00:00 | 1986-06-08 00:00:00 | MALE | 36 | Flat#182 | Married |  |  |  | 70 | HGN | 333 |  | 65 | NU | 3000 | 1990-01-13 00:00:00 | 30 | TH |  | Male | 3
The Above data is too large of employees and the main headers are merged. I need the details as per below template.
Employee Code | Name | Age | Desig/Relation | CNIC No. | Date Of Birth |  |  |  |  |  |  |  |  | 0 | Date of Joning  DD-MM-YYYY | 0 | CNIC No. | Name of Employee | Employee Age | Address | [NAME] | Name | CNIC | Date Of Birth2 | Age | Name3 | CNIC4 | Date Of Birth5 | [NAME] | Name7 | CNIC8 | Date Of Birth9 | Age10 | Name11 | Date Of Birth12 | Gender13 | Age14 | Name15 | Date Of Birth16 | Gender17 | Age18 | Name19
100 | ABC | 33 | Marketing | 123 | 1990-01-13 00:00:00 |  |  |  |  |  |  |  | 100 | 0 | 43018 | 0 | 123 | ABC | 33 | Flat#123 | Married | ADDDD | 111 | 0 | 61 | GHI | 222 | 0 | 60 | JB | 203 | 32886 | 30 | HGAA | 0 | Male | 5 | PHAI | 0 | 0 | 2 | 0
 | ADDDD | 61 | Father | 111 |  |  |  |  |  |  |  |  | 103 | 0 | 44713 | 0 | 111 | CCD | 36 | Flat#124 | Married | ABGGG | 11111 | 0 | 65 | 0 | 0 | 0 | 0 | BH | 1011 | 32886 | 30 | VGG | 0 | Male | 4 | ABGH | 0 | 0 | 2 | HVVV
 | GHI | 60 | Mother | 222 |  |  |  |  |  |  |  |  | 101 | 0 | 42767 | 0 | 201 | GHT | 36 | Flat#182 | Married | 0 | 0 | 0 | 70 | HGN | 333 | 0 | 65 | NU | 3000 | 32886 | 30 | TH | 0 | Male | 3 | 0 | 0 | 0 | 0 | 0
 | JB | 30 | Spouse | 203 | 1990-01-13 00:00:00
 | HGAA | 5 | Child-1
103 | CCD | 36 | Prod | 111 | 1986-04-09 00:00:00
 | ABGGG | 65 | Father | 11111
 | BH | 30 | Spouse | 1011 | 1990-01-13 00:00:00
 | VGG | 4 | Child-1
 | ABGH | 2 | Child-2
 | HVVV | 1 | Child-3
101 | GHT | 36 | Export |  | 1986-06-08 00:00:00
 | HGN | 65 | Mother | 333
 | NU | 30 | Spouse | 3000 | 1990-01-13 00:00:00
 | TH | 3 | Child-1
Employee Code | Name | Age | Desig/Relation | CNIC No. | Date Of Birth
100 | ABC | 33 | Marketing | 123 | 1990-01-13 00:00:00
 | ADDDD | 61 | Father | 111
 | GHI | 60 | Mother | 222
 | JB | 30 | Spouse | 203 | 1990-01-13 00:00:00
 | HGAA | 5 | Child - 1
 | PHAI | 2 | Child - 2
103 | CCD | 36 | Prod | 111 | 1986-04-09 00:00:00
 | ABGGG | 65 | Father | 11111
 | BH | 30 | Spouse | 1011 | 1990-01-13 00:00:00
 | VGG | 4 | Child - 1
 | ABGH | 2 | Child - 2
 | HVVV | 1 | Child - 3
101 | GHT | 36 | Export | 201 | 1986-06-08 00:00:00
 | HGN | 65 | Mother | 333
 | NU | 30 | Spouse | 3000 | 1990-01-13 00:00:00
 | TH | 3 | Child - 1