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…