Aug 25 2020 01:35 PM
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....
Aug 25 2020 01:42 PM
Aug 25 2020 01:50 PM
Solution