Forum Discussion
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...
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.