Pivot in Excel: Labels in tabular form

It was something brought up in a training, and I, being an Excel geek, picked this up for the simplicity of it and the level of annoyance that it caused me before knowing this tip.
- Choose Field Settings on a right click menu


- On Layout & Print folder, choose Show item labels in tabular form
- Then choose repeat item labels


 - There you go



Comments