I would like to be able to have thumbnail images of my photographs with information next to them (Location, Photo ID #, Date Photo Taken, etc.) that I can sort according to the column headers (like in Excel). I tried creating a Pivot Table in Excel, but it didn't work (may not have done it correctly). Is there any software available that is already set up to do this?
If you have a Mac this can easily be achieved in Aperture, I dont think you can do this in Lightroom.
I think this is what you ment, if you don't have a Mac, you can do this with ACDSee on Windows, maybe Picasa but I'm not sure about that.
Adobe Bridge is very handy tool for photos management, you can load all the images you have in it and sort them by name, date created, size, type and more. If you have Photoshop then Bridge is installed already on your system as it's part of the Photoshop package.