In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a database programmer when you create your data layouts.  If you missed those posts, you should check them out here: Think Like a Database Designer Before Creating an Excel Dashboard Chart How-to Insert … Continue reading How-to Convert an Existing Excel Data Set to a Pivot Table Format