How do I add a description column to a Pivot Table
Assuming the attached image is suitable for your format, do the following:
- Convert your data into 2 columns (with column names at top).
- Create a pivot table containing your 2 columns of data.
- Drag the data field names into the row label section.
- Right-click on the pivot table and select Pivot Table Options, select the Display tab, select the checkbox Classic Pivot Table layout, click on OK
- Right-click on the first column and deselect Subtotal Model Number (or whatever the name of your first column is
I deselected the blank value in the first column list to clean up the table