Forum Discussion

FRobinson25's avatar
FRobinson25
Copper Contributor
Oct 08, 2019

Pivot Table not sorting

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

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    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.

Resources