Excel 2007 : Unique Count of Entriesw/ Pivot Table showing each unique entry + count

Hello,

I'm trying to collect data for an access management system and want to particularly gather the total value of each of the systems which are listed in columns. I have about 15 documents now that each have their own list of over 10 systems for sometimes 100 of rows.

There is other information as well I'd like to gather such as the location or job site id and things like that, but any of direction to finding a good method. I've always liked Excel, what a machine! I'm in a rush to get this information and I apologize for the blunt request.


Examlpe!