Pivoting can be a very useful mechanism for summarizing data. Among other functions, pivoting data can allow you to sort, count, total or give the average of various data points. Pivoting data allows users to recognize patterns in that data, and can provide a way to visualize complex modeling schemas.
Traditionally, pivoting data has meant using a spreadsheet program such as Excel, and learning how to create a Pivot…