Cleaning up data after PDF Conversion

[Anonymous]

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 to make the highlighted names as column headers and the value that belongs to each column is the row after the label. 

if there were 3 tables, I was able to transform them individually and append them, but being some many tables I could not do it. 

 Could you give me some ideas in how to go about formatting the data? This is so messy.  I watched a lot of videos yesterday I still have not figured out a solution! Thank you in advance! 

[adudani]

@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]

@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.