How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask yaccad Your Own Question
yaccad
yaccad, Consultant
Category: Microsoft Office
Satisfied Customers: 69
Experience:  15 Years of Information Technology experience specializing in Network and Systems security.
13609916
Type Your Microsoft Office Question Here...
yaccad is online now
A new question is answered every 9 seconds

I have a 1400+ page pdf that has data grouped and organized

This answer was rated:

I have a 1400+ page pdf that has data grouped and organized into columns and rows within it. I am trying to convert this into an excel file iso that I can sort the data. Also need to keep the data grouped. Ive tried 'convert to excel' option in adobe, doesnt come out in a form I can sort properly. Wondering if an expert can accomplish what I am trying to do here.
JA: When did you last update Excel?
Customer: Purchased excel in February 2017, have not manually updated, how do I check to see if it has been auto updated?
JA: What have you tried so far with your Excel?
Customer: I have tried 'export to excel' out of Adobe
JA: Anything else you want the Software Expert to know before I connect you?
Customer: cant think of anything else
Are you able to post the pdf here?
Customer: replied 8 months ago.
ugh its saying file is too large. Its 8.67 mb. Its saying the cutoff is 5 mb.I uploaded it to a dropbox acct. Here's the link if that will work: https://www.dropbox.com/s/e3ec0m6i4d8m3o4/GLASSCOCK%20CAD%20MINERAL%20APPRAISAL%20ROLL.PDF?dl=0
Ok thank you. I’ll get back to you as soon as I take a look at it
Customer: replied 8 months ago.
ok. no rush. can wait till next week.
Thanks I’ll keep you posted.
Customer: replied 8 months ago.
sounds good
Customer: replied 8 months ago.
Hey, took a look at it.
I think you did more than I could figure out how to do.
Still doesnt solve the problem though....
I'm looking to be able to sort it.I attached a screenshot to show what I'm talking about.
Basically I'm trying to be able to get it so that I can sort by "property description" and then by "value"Example in the screenshot - I'd want to be able to sort it so that all the owners of "T4S BLK 35 SEC 16" in the entire spreadsheet wouldnt be sorted by their names, but would be sorted by property, then sorted by their value in the property, so that I could basically see ok, here's the list of 50 owners in T4S BLK 35 SEC 16, Joe Blow's value is 5000, ***** *****s is 4900, down the list to Area Royalty Ltd who owns two positions in the property, one worth 1400 and one worth 410.
If not by value then by the RI in column F...Is there any way to do this with excel? Or would I just have to go down the list of these 1400 pages and separate them all by hand?Thanks for the speediness. Hopefully theres a way to do this in excel, otherwise it might be a long week lol
Let me know if you know a way to accomplish what I'm trying to do with this spreadsheet.
Thanks
Matt H
Customer: replied 8 months ago.
hey btw - I can still pay you something for the effort. This thing is a *****

Hi yeah I realize it's not easy to sort even after the conversion because of the nature of the file. I manipulated the file in python and am uploading a new version that you can sort at the header. I hope this will make it somewhat more usable for you:

https://www.dropbox.com/s/bs50rp0d6vc3nwt/GLASSCOCK%20CAD%20MINERAL%20APPRAISAL%20ROLL%20-%20sortable.xlsx?dl=0

yaccad and 6 other Microsoft Office Specialists are ready to help you
Customer: replied 8 months ago.
Hey. Messed around with it. Its something, def more than I could've done, but its sorta looking like the only way to be 100% accurate will be to go through page by page by hand. Part of the issue is how the data changes columns throughout the sheet. I figure youre right about it being due to the nature of the file. Wish I knew how to quickly put this in a searchable database or something in order to crank out what I'm trying to do with this data. Thanks for the effort.