Posts by Bongoquery

Thanks anyway

PDF File attached. If you need anything else let me know. Thanks again.

Thanks. I tried that but all I got was three tables with a message saying this table is empty in each of the tables.

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.

Thank you.