How to Copy Word Table to Excel so that the number of Rows are the same?

Attached below is a Word doc with a sample table that I try to copy to Excel. One row in the Word table may become multiple rows in Excel. That causes other problems when processing the Excel table. Ideally, the copy to Excel gives one row for each ACTION FIELD entry as it does in this Word table.

Word Table showing first 8 rows:
Shows first few lines of Word Table
Excel Table after copying first 8 rows has 22 rows. I would like Excel to have only 8 rows, since that is what Word had.
Shows first few lines of Excel Table - too many rows
Both the full sample Word table, and the attempted copy to Excel (with 22 rows) is attached.
Word_to_Excel_Issue.docx
ExcelHasTooManyRows.xlsx
LVL 33
phoffric\Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
I'm guessing that if you did a global search for the newline character (Chr(13)) and replace it with a space that you could maintain the structure when imported into Excel.
phoffric\Author Commented:
>> global search for the newline character (Chr(13))
In Word, I presume? How to use that (Chr(13)) in a global search?

What I did try is Ctrl/H. Special -> Manual Line Break; and replaced that with a period followed by a space. Almost got there. Although the first row, 2nd Column did shrink a little, it didn't shrink completely. Got:
version date. 
Additional information is shown below

Open in new window

I don't know how to make the two lines become one.
Martin LissOlder than dirtCommented:
In Word try this.
2019-01-12_19-22-24.png

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

phoffric\Author Commented:
The solution is to do a global replace for both the manual line break and the paragraph mark. Thank you Martin.
phoffric\Author Commented:
The solution is to do a global replace for both the manual line break and the paragraph mark. Thank you Martin.
When I get to work, I'll record a macro that does these two global replaces. Hope it works at work.
phoffric\Author Commented:
How do you use the chr(13) to do the global replace?
Martin LissOlder than dirtCommented:
In the Find & Replace dialog (that you can open with Ctrl+H)
In the "Find what:" box, press and hold the Alt key, and then enter the numbers 013 from the number pad that's on the right side of most keyboards of the keyboard. 013 is the carriage return character. You could also try 010 which is the linefeed character. If either one removes anything, follow it up with the other one.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.