SOLVED

Pivot Table Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1612072%22%20slang%3D%22en-US%22%3EPivot%20Table%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612072%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20am%20not%20sure%20how%20to%20search%20for%20this%20or%20whether%20it%20is%20actually%20feasible%20so%20I%20thought%20I%20post%20here.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20returning%20to%20data%20analysis%20after%20some%20years%20and%20excel%20has%20changed%20a%20lot.%3C%2FP%3E%3CP%3EI%20used%20to%20create%20many%20pivot%20tables%20but%20the%20controls%20look%20all%20very%20different%20now.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20my%20pivot%20table%20and%20I%20was%20just%20wondering%20whether%20it%20is%20possible%20to%20shift%20the%20quarter%20and%20months%20into%20column%20B%20and%20column%20C%20respectively%20while%20leaving%20year%20in%20column%20A....%20I%20just%20think%20it%20would%20be%20easier%20to%20read%20that%20way%20and%20I%20recall%20pivot%20tables%20doing%20this%20automatically%20long%20long%20ago....%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pivot.PNG%22%20style%3D%22width%3A%20444px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214706iCD80005C26DF37D0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22pivot.PNG%22%20alt%3D%22pivot.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612086%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612086%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F740158%22%20target%3D%22_blank%22%3E%40Poogermum%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20speak%20about%20tabular%20form%2C%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20339px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214707i6B0B420A4D2C9E57%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ethat's%20under%20Design%20tab%20if%20you%20stay%20on%20PivotTable.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612101%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612101%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20that's%20what%20I%20have%20meant.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1612346%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1612346%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F740158%22%20target%3D%22_blank%22%3E%40Poogermum%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

3 Replies

@Poogermum 

Perhaps you speak about tabular form,

image.png

that's under Design tab if you stay on PivotTable.

Best Response confirmed by Poogermum (Occasional Contributor)
Solution

@Sergei Baklan 

 

Thank you that's what I have meant. 

@Poogermum , you are welcome