Forum Discussion
Importing Credit card statement to power query in PDF format
When I load my credit card statement that is in PDF format into power query I find there is absolutely no consistency in the number of columns or the information on each table/page. How do I clean up...
Hi Eqa ,
Select to Combine & Transform Data.
Click OK.
And then we'll get to those. We'll then use that as a basis for modification.
I have uploaded an Excel file containing the steps for your 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
Here is a screenshot showing that my info is much messier than yours. Can I clean this up?