Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

I currently have a 4-column database table that I want to display in a "pivot" format. This has proven to be more difficult than I first thought it would be. I'm not an expert with either PHP or MySQL ...

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. Once you select the portion of your spreadsheet that contains the target data, then define it as a ...