+ Reply to Thread
Results 1 to 2 of 2

Word listed items to Excel particular format

  1. #1
    Registered User
    Join Date
    05-15-2022
    Location
    detroit
    MS-Off Ver
    excel 2010 in windows 7
    Posts
    5

    Word listed items to Excel particular format

    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
    Attached Files Attached Files
    Last edited by rengeroni; 06-04-2022 at 07:44 PM. Reason: . . . better explanation of the Raw Data into a Desired Format . . .

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,696

    Re: Word listed items to Excel

    No files attached. Check that your files are under 1MB. If they are over 1MB then put them in a zip file first. The zip file must be under 9.77MB.

    The paper clip icon does not work for attachments. To attach a file:

    1. Under the text box where you type your reply click the Go Advanced button.
    2. On the next screen scroll down and under the Attachments section click the Manage Attachments link, which will show a pop-up window.
    3. Click the Choose File button to select a file to attached.
    4. Click the Upload button to upload the file.
    5. Then click the Close This Window button. Your file is now attached to your post.
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find not listed items
    By plans in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-27-2021, 02:08 PM
  2. [SOLVED] Assigning the same occurrence count to listed items that have been multiplied
    By Marbleking in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-27-2020, 12:29 PM
  3. [SOLVED] calculate Sumproduct weighted average for the listed items
    By abdumon7 in forum Excel General
    Replies: 7
    Last Post: 04-16-2019, 06:22 AM
  4. [SOLVED] Look for a word with a range and only display a row where the word is listed
    By bbarth in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-15-2015, 10:29 AM
  5. [SOLVED] Non listed item to be counted in other items
    By skhari in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-21-2014, 02:08 PM
  6. Obtaining sum from multiple listed items
    By dainbram in forum Excel General
    Replies: 4
    Last Post: 09-08-2008, 06:50 PM
  7. [SOLVED] Query Items Listed During a Specific Time Period
    By DukeDevil in forum Excel General
    Replies: 0
    Last Post: 07-06-2006, 03:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1