Within the GUI there is the ability to Export data from various pages; such as "Systems | List Systems" and then 'Export to Excel". It is then possible to manipulate the data as you required.
To retrieve more customized information from TPAM, reviewing the CLI / API commands may offer further options.
Review the "CLI Commands" available to you in chapter 40 of the TPAM Administrator Guide starting in chapter 40 "CLI Commands" and Chapter 41 "Application Programming Interface (API)"
Review the 'Data Extracts' in chapter 26 of the same document. It may be possible to utilize the CSV data and manipulate it outside of TPAM.
Using Custom Fields may also offer some further options for customization.