Forum Discussion

Poogermum's avatar
Poogermum
Brass Contributor
Aug 25, 2020
Solved

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....

Resources