How to arrange the data in the required format

HI

i have data in excel in the unorganized manner with blanks im pasting the some of the data







1 GTR4562625 2 KGY4159984
Elector's Name: SARIKA Elector's Name: NAGAIYA CHARY
Husband's Name: SOMESH Father's Name: NARAYANA
House No: 1-3-176/8 House No: 2-1-1-1/1/4
Age: 29 Sex: Female Age: 52 Sex: Male
4 KGY0191692 5 KGY0191189
Elector's Name: M Satyanarayana Elector's Name: M SANGEETHA
Father's Name: M Mallaiah Husband's Name: SHRAVAN KUMAR





and the format in which i want (second scenario pasted below)



S.No EPIC No. Elector's Name: Husband's Name: House No:
1 KGY4159984 SARIKA SOMESH 1-3-176/8