Forum Discussion
Power Query get data from pdf
Latest version of Excel via Office 365 on WINDOWS. I have a Pdf that has a single table split into dozens of tables by page breaks. This is the first time I have used Get Data and Power Query. I...
Nobody have detailed knowledge, if only Guy Hunkin . In general Pdf.Tables - PowerQuery M | Microsoft Docs has an option to combine tables from different pages which shall work by default
However, I assume that's only if you have headers for both parts of the table. If your parts returned as
and
you may append one to another to another to receive resulting table. Yes, that's required some manual work.