Here is an elementary suggestion. It would not be difficult to write a Python script to make a csv file from your text files, adding commas at the appropriate places to separate fields. Then the csv file can be browsed in Excel (or some other spreadsheet). A0 and C1 records could be written to separate csv files.
There are Python programs to create Excel spreadsheets, and they could be used to format the data in more sophisticated ways. -- http://mail.python.org/mailman/listinfo/python-list
