pivot table serves you in any of the following situations

􀁑 You need to find relationships and groupings within your data.
􀁑 You need to find a list of unique values for one field in your data.
􀁑 You need to find data trends using various time periods.
􀁑 You anticipate frequent requests for changes to your data analysis.
􀁑 You need to create subtotals that frequently include new additions.
􀁑 You need to organize your data into a format that is easy to chart.