How to map data in txt with chaos format to excel?

Help
, ,
1

Hi everyone

There is a txt, with chaos data, which actually is a diagram, i want to map the value into different cells of excel.

the txt is

image
image607×824 19.1 KB

the excel looks like this:

image
image816×490 12.9 KB

The excel format will be input manually, i need to capture the cell content. But i don’t know how to capture separate words in one line of txt, such as “Unlisted Not applicable Not applicable Not applicable Not applicable Not applicable 1,434”, need to be captured as “Unlisted”, “Not applicable”, “1,434”. The word length may change, it may be “applicable”.

I want to use regular expression’s matches, but cannot make it, can anyone help me maybe just the idea or just map one line of my data into excel as an example ? thx!

the txt and excel here:
test.zip (6.9 KB)

thx!!!