Pivot Tables in Excel

Who knew Excel pivot tables were so useful? I had to create a report based upon an existing data set. The issue was the original data was only organized by time within one day across many excel spreadsheets. The new report needed to be a multi-day report grouped by number of running processes instead. I can only imagine what a taxing pain in the butt it would have been to manually crunch the data together.

Thankfully, I had sort of heard of pivot tables before, so I thought I would check out what they were before I started. I stumbled across an article that explained them well enough for me to know that this was exactly what I was looking for.

A couple of clicks later, I was viewing summarized information in a way that was completely independent from the actual data structure!