This rule is run from our ERP system and in the old days would come out on green bar paper with all of the headers wrapping around and the data following suit so it could be easily read. Now that Monarch models are a thing of the past here, getting that wrapped report to somehow separate into...
Is there a way in Excel to take a report in a .prn or .txt file and have the multiple "wrapped" rows appear in one row. Some people use Monarch models for this but I don't want to spend the money on the software if Excel can produce such a thing. My report headers look something like this...