Does anyone have a suggestion how to quickly transform data table I exported from PDF to Excel. Is there a more effective way to export PDF files to Excel? I already tried using Power Pivot "Get Data" and it returns empty tables, so I cannot use this option. One example would be below. I have tons of tables that I need to "clean up". Sometimes it is merged cells, sometimes a column missing a year header, etc. I am using an Acrobat PDF exporter....Thank you!
Please see this example. There is a merged cell that contains a lot of data in it.