Expand Pivot Table Column labels vertically / downwards

%3CLINGO-SUB%20id%3D%22lingo-sub-1574334%22%20slang%3D%22en-US%22%3EExpand%20Pivot%20Table%20Column%20labels%20vertically%20%2F%20downwards%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574334%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EAs%20we%20know%20we%20can%20expand%2Fcollapse%20Row%20Headers%20or%20Column%20Headers%20in%20Pivot%20Tables%20to%20reveal%20details.%20When%20we%20expand%20column%20headers%2C%20it%20expands%20rightwards.%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EMy%20objective%20is%20to%20make%20it%20expand%20downwards%20(vertically).%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20see%20in%20the%20attached%20images%20that%20clicking%20the%20plus%20sign%20expands%20a%20column%20label%20but%20rightwards%2C%20not%20downwards.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20would%20really%20appreciate%20if%20someone%20can%20help%20me%20with%20this.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you%20so%20much.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1574334%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1574401%22%20slang%3D%22en-US%22%3ERe%3A%20Expand%20Pivot%20Table%20Column%20labels%20vertically%20%2F%20downwards%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F751212%22%20target%3D%22_blank%22%3E%40sohailzamani%3C%2FA%3E%26nbsp%3BI%20dare%20to%20say%20that%20this%20is%20just%20how%20collapsing%2Fexpanding%20works%20in%20pivot%20tables.%26nbsp%3BPerhaps%20a%20silly%20suggestion%2C%20but%20why%20not%20use%20the%20column%20headers%20as%20row%20headers%20in%20stead%3F%20The%20attached%20workbook%20demonstrates%20what%20I%20mean%2C%20although%20I%20don't%20know%20if%20this%20is%20similar%20to%20your%20actual%20pivot%20table.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1576422%22%20slang%3D%22en-US%22%3ERe%3A%20Expand%20Pivot%20Table%20Column%20labels%20vertically%20%2F%20downwards%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576422%22%20slang%3D%22en-US%22%3EGreat%20thanks%20for%20your%20kind%20response.%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20are%20right%20that%20I%20can%20also%20make%20the%20column%20headers%20become%20the%20row%20headers%20but%20that%E2%80%99s%20what%20I%20just%20don%E2%80%99t%20want%20to%20have%20in%20my%20final%20results.%3C%2FLINGO-BODY%3E
Occasional Contributor

As we know we can expand/collapse Row Headers or Column Headers in Pivot Tables to reveal details. When we expand column headers, it expands rightwards. My objective is to make it expand downwards (vertically). 

 

You can see in the attached images that clicking the plus sign expands a column label but rightwards, not downwards. 

 

I would really appreciate if someone can help me with this. 

 

Thank you so much. 

2 Replies

@sohailzamani I dare to say that this is just how collapsing/expanding works in pivot tables. Perhaps a silly suggestion, but why not use the column headers as row headers in stead? The attached workbook demonstrates what I mean, although I don't know if this is similar to your actual pivot table.

Great thanks for your kind response.

You are right that I can also make the column headers become the row headers but that’s what I just don’t want to have in my final results.