This question already has an answer here:
I added comments to a bunch of cells. When I then sorted the cells, the comments did not follow their original cell and now was connected to the new cell. This is a massive problem and now my comments are all messed up.
This is the same problem that was brought up here, but was not answered. Google spreadsheet sorting messes up cell comments