Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cleaning up data after PDF Conversion

Hello,   I needed to convert a PDF of pricing agreement to an excel and after conversion it resulted in 299 tables.  as you can see these data have turned into stacked tables. I would like t...
Need Help
adudani's avatar
adudani
Memorable Member
3 years ago

Anonymous ,

 

if the requirement is 3 tables, duplicate the query 3 times.

Filter each table for the different headers using ( remove top N rows).

Promote the row you want into headers.

 

This should work if the pdf is standardize.

 

Please accept this as the solution if it resolves the question.

 

Appreciate a thumbs up if this is helpful.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    adudani Thank you for the reply. What do you mean if the PDF is standardized?  What are the prerequisites? I am afraid that I am unable to complete the task.

     

    the PDF version has 55 pages but each page follows the same PDF format. 

    I have 299 tables ( microsoft reads as tables when converting ) that are stacked onto each other with repeated headers in the rows. I only used 3 tables as an example BUT I actually have 299 "tables"  that are stacked on top of each other after conversion.