DocHub is an innovative platform designed to enhance your document management experience. With features that streamline editing, signing, and distribution, it allows users to effortlessly work with PDFs. Our editor is equipped with tools that cater to all your document needs, making it easy to import, export, modify, and sign documents online. Whether you’re collaborating through Google Workspace or handling forms, DocHub ensures a smooth and interactive workflow for free.
Start using DocHub today to simplify your document management and effortlessly extract tables from PDFs!
so one of my clients emailed me this PDF and you can see that it has these pricing tables multiple of them on the page and I wanted to get all of this data into Power query for further analysis but the problem is when I try to load this page into Power query it treats this entire two tables as one table combining all of them into a giant data set and in this video we are going to use power query to solve this problem you dont want to miss the ending because Im going to show you how we can actually create a custom function in power query so that next time you have to cut a table in the half you can use that function instead of repeating all these steps lets go Ill open a brand new Excel file and go to the data ribbon get data from file from PDF lets point to the PDF and import that and you can see the issue here this table table 002 is the combined table that has all my prices but everything in one place and I would like to split it after column 6 so that we can take all of these i