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