To summarize your data without using formulas: Sort the data by what you would like to subtotal Go to the Data tab On the right of the ribbon, click Subtotal in the Outline group. Choose the field you’d like to subtotal by (the Sorted Column) Select the Function that you would like to use Select …
Tag - Transpose
