Power Query not the best choice

[GScott]

I am trying to extract credit card transaction data from a pdf. This pdf comes monthly and the number of transactions can vary.
I cannot extract the data as tables because some data is excluded, and can only extract pages. But each month the results of the query differ despite the pdf looking the same. It seems like power query is not the right tool.
Is there another tool that might work better in extracting from the pdf into excel.

 

[alansidman]

tough to evaluate from your description. Suggest you use XL2BB to post some sample data and a mock up of the expected results. 10-12 records should be sufficient.

 

[GraH]

Issuers statements in PDF are though, but do-able with Power Query as long as you can find patterns. May not be as straightforward as one would like. I spent some evenings with loads of trial and error approaches to get mine sorted out. Needed to use a few List functions.