I have never really used Monarch, but I have read and completed the associated tutorial and understand how the program works. I have the ugliest report known to mankind and cannot find a way to get it into Excel. I can get very close with my model, but cannot reach an end.
I have a multi level report (attached) in which I need the general headers that you will see (Purchase order #, Shop Order #, Model etc). I also need the "header info" for the following: "for ship to code", "order id", and "order desc".
The problems arise when you see items like PO: EI-08046/MKH. If you notice the line directly below looks more relevent (with the Shop Order) than the line above it (except I need the PO #). There is no Quantity (req, prom or ship) data on the first line. I would like to compress these into one with the relevent data.
Other problems arise when you see PO number LG0801. 1st and 2nd lines have the same issue as above, but the 3rd, 4th, 5thand 6th now have relevent shipping and promise dates. I want each of these lines, but with the relevent data attached (PO, SO, Model #).
To further complicate, in PO number 8100018088, you see that all the relevent data is on the first line.
If it would be easier leave the items I called "header info" above off and run a seperate report for these that will also bring in the SO# (or other "primary key"), so I can reference this data....that would work as well.
I hope this isn't too confusing, but I cannot find a way to do this. I REALLY REALLY appreciate any help given!
Thanks in advance