When should I use a pivot table?
A pivot table provides summary or aggregate data when comparing two or more aspects, e.g., product and region. It allows you to manipulate and group data quickly and efficiently. You are able to pivot the table to rearrange columns into rows and vice versa on the fly without having to request additional data. Filters are applied to present specific values.
Use a pivot table when you want to rearrange your data set instantly.