Forum Discussion
Poogermum
Aug 25, 2020Brass Contributor
Pivot Table Formatting
Hi
I am not sure how to search for this or whether it is actually feasible so I thought I post here.
I am returning to data analysis after some years and excel has changed a lot.
I used to create many pivot tables but the controls look all very different now.
This is my pivot table and I was just wondering whether it is possible to shift the quarter and months into column B and column C respectively while leaving year in column A.... I just think it would be easier to read that way and I recall pivot tables doing this automatically long long ago....
3 Replies
- SergeiBaklanDiamond Contributor
- PoogermumBrass Contributor
- SergeiBaklanDiamond Contributor
Poogermum , you are welcome