I have a ton of invoices I've extracted from a couple of email addresses that I then turned into Excel documents with the Able2Extract PDF to Excel convert.
The problem however, is the data looks like this:
Untitled-1.jpg
And I'm wanting it to have one big excel sheet with multiple columns that have:
DATE INVOICE BILL COMPANY BILL FIRST NAME BILL LAST NAME BILL ADDRESS BILL CITY BILL STATE BILL ZIP SHIP DATE DESCRIPTION
With the data of each invoice in a row.
Each invoice is in an excel with the sheet labeled Sheet1.
Here' a dropbox link of a before and after of how I am aiming for it to look.
https://www.dropbox.com/s/x0k1zsw6dnwiz4b/test data.xlsx?dl=0
How can this be done? Any guidance?
I'm somewhat savvy at modifying scripts once I have an idea how they work. I just have no idea where to start.
The problem however, is the data looks like this:
Untitled-1.jpg
And I'm wanting it to have one big excel sheet with multiple columns that have:
DATE INVOICE BILL COMPANY BILL FIRST NAME BILL LAST NAME BILL ADDRESS BILL CITY BILL STATE BILL ZIP SHIP DATE DESCRIPTION
With the data of each invoice in a row.
Each invoice is in an excel with the sheet labeled Sheet1.
Here' a dropbox link of a before and after of how I am aiming for it to look.
https://www.dropbox.com/s/x0k1zsw6dnwiz4b/test data.xlsx?dl=0
How can this be done? Any guidance?
I'm somewhat savvy at modifying scripts once I have an idea how they work. I just have no idea where to start.
