Several months ago, I learned how to create a pivot table. This isn’t something I used all the time, so I deleted the one I created.
Now I’m trying to create another one, but when the Pivot Table Editor appears on the right of my screen, and I click Choose>/Add>Rows and try to choose category, category isn’t showing up at all.
I’m following the instructions on this page: Pivot table instructions
Am I missing a step? Have I screwed something up that can’t be fixed? Please help. Thanks!