If you can post a sample of the report, or email it, it will be easier to advise accurately. But a couple of tips might be generally helpful - use the Detail template for the most granular level of data, use Appends for any data that appears above the relevant Detail line, and Footer for data that appears below.
In your case, it sounds like the Advanced Field Options might help - if the 3LLA008 data appears on some relevant Detail lines, then you could set blank values of this to repeat the value from previous records.
To get an idea of how that works, you could use Lesson10.xmod and Classic.prn from the sample files, and look at the "Media" field from the Detail template there.
If you want a model built to solve your issue, we can do it, and go through it for you in a webex if that helps.
Thank you so much for your quick response. Fortunately, I was able to get the desired results using a combination of SQL and Excel. However I will still look into the Advanced Field Options as you suggested. I am new to Monarch and it's a very useful tool, so thank you again for the suggestion.