I was recently working on a spreadsheet for a co-worker that behaved strangely. When ever we tried to sort a column, the data would disappear. We found out we had “dirty cells” in the worksheet. That means the cells that appeared blank actually had data in them and when we chose sort for the column, all our data moved to the bottom of the spreadsheet, giving it the appearance of “disappearing”.
I found this link that helps you clean up your cells in the spreadsheet. It worked for our sorting issue. Here’s the link: