Merged cells issue

[Aleksandra24521440jn0p]

Hello,

Hello,

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.

[MeenakshiNegi]

Hi Aleksandra,

Sorry for the delay in response.

Could you please confirm if you experienced this issue with a particular PDF?

Are you trying to export PDF using the Acrobat Online account?

Would it be possible to share the PDF with us so we can replicate the behavior?

Thanks,

Meenakshi

[try67]

Unless the file has been properly tagged, exporting a PDF to another format will never be 100% accurate, as PDF files were meant to be the last stage in the document workflow.