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...
I actually discovered, by saving the Pdf as a word document, that tables had been saved in the pdf with tabs that bypassed null columns, so, although there were column headers, Power Query was always going to build the columns from actual data. So I need to manipulate extracted data myself to insert columns where missing. That's life.