I am basically a novice in Power Query.
I have, using Kofax Power PDF Standard software, converted a PDF file to the Word Document File: “Converted Word File Document” (Attached). I have saved this word document as a Plain text document in File: “Plain File Document” (Attached).
I have then through Excel, New File, Data, Get Data, From File. From Text/CSV, gone into the Power Editor query and loaded the file to Excel.
The end result I would like is an Excel Worksheet with five separate columns named Date, Details, Withdrawals, Deposits and Balance respectively with the appropriate data in each column.
What I am getting, however, is the contents of File: “Resultant Excel File” (attached).
I would appreciate if someone could kindly help with what I am doing wrong.