Extract paired lab data from txt file and move to excel

I hope someone might be able to advise - I need to extract data from lab (and other) reports and place this into excel for analysis. The data is exported as a .txt file and this is what I need to use to extract information. The file will be located in a folder and should be moved to another folder once the extraction is complete. The data is generally paired with a title or some other identifier and I have also attached a word doc so you can see the data field identifier (in red) and the data to be extracted (in blue) along with section titles (in bold). I’ve seen a few ways of doing this but just wondered what would be the best approach please and if you might be able to send an example that would be very appreciated.Base64 translated.txt (692 Bytes) sample.docx (12.0 KB)