PDF to Google Sheets Migration

I need all mixed data—numbers and text—lifted accurately from a PDF and placed into Google Sheets. Once the transfer is complete, I expect advanced formatting: formulas where they add value and conditional formatting set up to highlight any duplicate entries automatically.

Deliverables:
• A Google Sheet populated with every record from the PDF, checked for integrity
• Conditional-formatting rule that flags duplicates clearly
• Any supporting formulas documented in-cell or with a brief note so I can tweak them later

Attention to detail is critical; the sheet should be ready for immediate analysis the moment you hand it back.