Hi Patrick and welcome to the forum.
For ease of use here I think I would skip the idea of an append. Just treat the first line of each Agency as the detail and then grab the Term/Price as a multi-line field.
Now create some calculated fields for all the possible Term calculations ( I assume that realistically that will be a limited number) and use the TEXTLINE() function in SEARCH mode to grab the data from which ever line show the 12 or 24 or 36 month, etc., values.
To separate the GS values from the rest of the field you can than use the RSPLIT() function. Once you see how that works you can reduce the number of 'intermediate' fields by taking a more direct route with the field formula - but get the separate fields first as it is easier to check and test the results.
If this is familiar territory for you let us know how it works out. If not, let us know and we can provide more detailed guidance.
I tried to apply it to a similar section in a sister report but found
there must be a limit on the record/field length. It truncated part
of my return.
Glad that worked for you.
The maximum length of a Character field type is 254 characters. However when you need more make the field a MEMO type and that will give you 64k characters to play with.
If you do that you will usually need to make use of the 'Show Field Contents' menu option in order to display all of the contents of such a potentially large field.