I have 13 PDF documents, each 200 pages, that I am converting to Excel.
When converted, everything populates into column A only. I need to retrieve specific data from column A and place into separate columns. What I need to do is where column A = OWNER, copy the name and address into separate columns until column A = BUILDER, then copy the Builder name and address into separate columns until column A = Phone. All I need is to extract the Owner and Builder from the spreadsheets. I have attached a sample of the document and highlighted the owner info in yellow and the builder info in pink. The highlights are only on the sample attached and not on the actual spreadsheets converted from PDF. Any help would be greatly appreciated.SPREADSHEET SAMPLE.xlsx
Bookmarks