Word listed items to Excel
I’m using MS Word/Excel 2010 on an Intel i7-3770 CPU 3.40Ghz 64-bit OS pc with MS Windows 7 Ultimate c2009 Service Pack 1
How do I copy several thousands lines of Word listed items (Word Raw Data) to Excel into a particular format (Desired Format) . . .
WORD RAW DATA
ABRA
99.75%
Returns transmitted
394 of 395 clustered
As of 2:47 PM - May 13, 2022
Governor
ABRA, CORDILLERA ADMINISTRATIVE REGION
Partial, results data as of May 13, 2022, 2:47 PM from 99.75% of Returns
1st
VALERA, NIC (ASENSO)
74,288
2nd
BERSAMIN, TAKIT (PDR)
63,478
Vice Governor
ABRA, CORDILLERA ADMINISTRATIVE REGION
Partial, results data as of May 13, 2022, 2:47 PM from 99.75% of Returns
1st
BERNOS, JOY (ASENSO)
102,283
2nd
BERSAMIN, CHARI (PDR)
34,123
Provincial Board Member
SECOND PROVDIST, ABRA, CORDILLERA ADMINISTRATIVE REGION
Partial, results data as of May 13, 2022, 2:47 PM from 217 Returns
1st
BRAGAS, RUSSELL (ASENSO)
65,475
2nd
SEARES, ALLAN (ASENSO)
52,726
Provincial Board Member
FIRST PROVDIST, ABRA, CORDILLERA ADMINISTRATIVE REGION
Partial, results data as of May 13, 2022, 2:47 PM from 177 Returns
1st
BAROÑA, VICTORINO JR. (ASENSO)
42,955
2nd
GAYAO, HENRIETTA (ASENSO)
39,464
5,159
Congressman
LONE LEGDIST, ABRA, CORDILLERA ADMINISTRATIVE REGION
Partial results data as of May 13, 2022, 2:47 PM from 394 Returns
1st
BERNOS, CHING (NP)
122,223
2nd
AQUINO, CARLOS (AKSYON)
5,159
DESIRED RESULT
A B C D E F G
ABRA, CORDILLERA ADMINISTRATIVE REGION
ABRA 99.75% Returns transmitted 394 of 395 clustered precincts As of 2:47 PM - May 13, 2022 Partial, results data
Governor
1st VALERA, NIC (ASENSO) 74,288
2nd BERSAMIN, TAKIT (PDR) 63,478
Vice Governor Partial, results data
1st BERNOS, JOY (ASENSO) 102,283
2nd BERSAMIN, CHARI (PDR) 34,123
Provincial Board Member Partial, results data
1st BRAGAS, RUSSELL (ASENSO) 65,475
2nd SEARES, ALLAN (ASENSO) 52,726
Provincial Board Member Partial, results data
1st BAROÑA, VICTORINO JR . (ASENSO) 42,955
2nd GAYAO, HENRIETTA (ASENSO) 39,464
Congressman Partial results data
1st BERNOS, CHING (NP) 122,223
2nd AQUINO, CARLOS (AKSYON) 5,159
pls refer to the 2 attached files for your perusal & a better picture of the challenge . . . thank you
2022DirPhil_word2excel01a.pdf
Bookmarks