Home

Pivot Table not sorting

%3CLINGO-SUB%20id%3D%22lingo-sub-900007%22%20slang%3D%22en-US%22%3EPivot%20Table%20not%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-900007%22%20slang%3D%22en-US%22%3E%3CP%3EI%20added%20some%20data%20to%20a%20pivot%20table%20and%20was%20trying%20to%20sort%20it%20from%20A-Z%2C%20the%20data%20sorts%20but%20for%20some%20reason%20the%20new%20data%20sorts%20beneath%20the%20original%20data%20and%20therefore%20won't%20mix%20so%20I%20can't%20group%20it%20appropriately.%20Any%20advice%20would%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-900007%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPIVOT%20TABLE%20PROBLEM%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESorting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-900080%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20not%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-900080%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422250%22%20target%3D%22_blank%22%3E%40FRobinson25%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20depends.%20You%20may%20have%20numbers%20as%20numbers%20and%20'numbers'%20as%20texts.%20You%20may%20have%20dashes%20within%20texts.%20Perhaps%20something%20else.%20Without%20sample%20it's%20hard%20to%20say.%3C%2FP%3E%3C%2FLINGO-BODY%3E
FRobinson25
Occasional Visitor

I added some data to a pivot table and was trying to sort it from A-Z, the data sorts but for some reason the new data sorts beneath the original data and therefore won't mix so I can't group it appropriately. Any advice would help.

1 Reply

@FRobinson25 

It depends. You may have numbers as numbers and 'numbers' as texts. You may have dashes within texts. Perhaps something else. Without sample it's hard to say.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies