I'm willing to learn how to do this but before I spend a lot of time trying to figure it out I'd like to know if this is possible, then where to start.
I'm using Tenable Nessus for vulnerability scanning at work, results are exported in CSV. Can Excel automate sorting the data based on different Nessus IDs, or groups of IDs? For instance, one system my have 10 vulnerabilities listed while 5 could be eliminated with one application upgrade (the application may be several versions old.) Could this go a step further and all vulnerabilities for a system be generated with only the current application (vulnerabilities) listed? Or, all applications with a vulnerability be listed, again cleaning up the older versions of an application so only the most recent is listed?
Thank you,
Ray

Nessus CSV export example:
http://www.tenable.com/blog/new-nessus-feature-added-csv-export