Importing Credit card statement to power query in PDF format

Hi Eqa ,

Try putting all the PDF files in a folder and then using PBI to connect to the folder.

Select to Combine & Transform Data.

Then we need to make some changes to the automatically generated M code.

Here, we drop the header of each table and then transpose the table.

For ease of management, I've created a new Enter table here to hold the required find and replace values:

Again, another new custom function is created for ease of management:

Next, start going back to the combined table and start replacing column names:

Get all column names.

Expand all columns.

PBIX and source files are attached for reference.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum