I am confused about how to approach an issue I am having. I have many PDFs that have data set up in them with the following format:
- - - - I T E M - - - - - - - - - - - F R O M - - - - - - - - - - - - - - - - T O - - - - - - - -
Group no. 01 NOFRILLS JOHN'S #0713 97 NO FRILLS LIONEL'S # 3948
Division 000 First division 999 Last division
Sub-division 000 First sub-division 999 Last sub-division
Department First department ZZZZZ Last department
Distribution 0000000000 First distribution 9999999999 Last distribution
Reference First reference ZZZZ Last reference
Extended function First function ZZZZZ Last function
Earning / deduction code (919) GST ON CLOTHING (919) GST ON CLOTHING
What I am trying to accomplish is a kind of transpose that would be similar to what Excel can do. I say transpose because all the ITEMS like Group no., Division, and etc are actually what we want as headers to be displayed across as the column headers. So, as an example:
| Group no. | Division | ...
| 01 | 000 | ...
| NOFRILLS JOHN'S #0713 | First Division | ...
| 97 | 999 | ...
| NO FRILLS LIONEL'S 3948| Last Division | ...
As it is, I am trapping whole lines and they are just spitting out in typical type rows. Honestly, I can also take the approach of getting these rows out of Monarch and export them into Excel and then writing a Macro that will transpose but I'm sure that there has to be a way to do it all with the very powerful Monarch.
Any suggestions are very appreciated.