Having issues converting word documents to Excel

[excelzero186]

HI- I have been using excel for creating final reports and when I export text from my software program I have to manually manipulate this to import into my report template in excel.

The first photo is how I want my text to be formatted into excel, two columns. Column 1- Depth and Column 2- Descriptions
The Second photo shows how the text is exported from my software program into word.
The Third photo shows how I copy and paste the word text into notepad, then manually delete rows and insert a tab to make it export correctly.
The Fourth photo shows the next step where I now have to delete empty rows in the excel.

The process of copying the text over to notepad then going through every line and deleting a row, deleting the text back, then inserting a tab and repeating about 400 times is a bit draining on the fingers.

Any suggestions on how to do this faster?

Thank you

[Pepe Le Mokko]

Administrative note

Welcome to the forum

missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[Pepe Le Mokko]

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks