I have a column of data (4600 obs). I clicked copy and then paste them into another column in the same spreadsheet. Some of the obs were automatically deleted during this process! The pasted data were only around 4200 while I didn't do anyting to them.
I tried to copy something from another spreadsheet and the same thing happened. It doesn't work with neither .xls nor .xlsx.
Can anyone help me to fix this? Thank you!