Student skips a place

I have two spreadsheets of data about the same class. When I copy a column from one to the other he whole column slips down a place. There are no empty spaces above the first name in either. How do I rectify this?

It shouldn't happen, it could be a glitch.
If you don't have any inconvenient, send us a backup to support@idoceo.net specifying which class and column are you copying so that we can reproduce the problem and provide a workaround , if possible , for this version.