Hello,
I was given this pdf to begin with.
A colleague was able to get it into this format for me: Now I have absolutely no idea where to go from here. I've used parsing, regex and text to column before, but I have never used them to this extreme of having data formatted in various forms going column to column and row to row. The real wild card is having sectional rows that appear between each set of records.
I basically broke it into 4 parts. A section header and field (part 1) and a record headers and fields section (parts 2-4)
Any recommendations? Thank you.
