Export text from PDF to import into Excel separating/placing text into specific columns

Hello, I'm hoping someone can help with this work project. I have experience with formulas and pivot table and am somewhat familiar with Power Query but apparently not enough for it to help me with t...