This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
In this post, I've loaded your text file, created a Table identifier and parsed the first table to columns as shown below.
In my next post I will turn the second part of the workflow into a batch macro that will parse each of the 45 tables contained in the text file and write each table to a separate sheet of an excel file.
At the moment all the fields are still text so we'll also have to look at how to turn some of them into numbers.