How to arrange the data in the required format

Closed
pradeep1019
Posts
1
Registration date
Tuesday March 25, 2014
Status
Member
Last seen
March 25, 2014
- Mar 25, 2014 at 02:12 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Mar 28, 2014 at 05:35 AM
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

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Mar 28, 2014 at 05:35 AM
data in that unorganized manner - was it on cell (A1) or in different cells
if in different cells in excel
select all and copy
and paste it in message window of this newsgroup

alternately (better alrernative)

save the file and upload to

speedyshare.com

and post the url wich will downlaod the sheet(file)

unless it is known which cell different words are parked it may not be possible go give a solution.
0