Hi all,
So at work I have this large pdf which we convert into a spreadsheet, however it does not do a very nice job:
Capture.PNG
I have done a very rudimentary sketch above. a - g are the column headings and the 1's are the data. The data is misaligned essentially to the headers, however they always have the correct amount of spacing. (This is one of the few issues I face. I can't remember all of the other issues, but I will list them when I get back into office tomorrow)
I did this 6 months ago (as it need to be done bi-annually), and used a lot of formulas including match, index, vlookups etc. However the whole process still took me like nearly a week to finish, not to mention how large and slow the file became.
I am just wondering if there are any clever programs out there/formulas I can use to streamline unorganised data sets?
Thank you,
Regards,
Bookmarks