I need to be able to copy a student, and their grade book data, into new classes. Kids get mixed up into new classes so although the columns stay the same for each class, the individual kids within the classes change and I’d like to be able to see their historical data and grades from last year in this year’s class. I can’t just copy and paste a column or tab as the data would then be next to a different kids name. I hope this makes sense! Is this possible?

Hello emilyokeeffe,
If you copy a column from one class to another and enable the 'copy cells option' shown in the image it will only transfer data that belongs to the same student. They won't be mixed up. It is a - moderately - smart copy.




You should also keep in mind that the student's sheet > Summary section will let you see the historical data of each student (on any class/year) that he is or was attending.

Find attached below a sample screenshot

This is great - thank you so much! One more question: is there a way to workaround the duplication of columns this creates? Eg if I have students from 4 different classes merging in to one, can I also merge the data into one column rather than have 4 duplicated ones?

I think you could create another column and calculate the average of the 4 columns. Since there is only one value, the average is equal to the column that holds the value. If you want you can hide the 4 "source-columns".

@emilyokeeffe, what tomka states is perfectly valid. You could easily add a folder/category that would do that for you. Just set the calculation as average.
If we had these two columns shown in the image:




It would look like this (and you can close the folder to see only the results)

There is however a slightly better solution if cells do not overlap, like in our example.
If we have this




and tap on Tools > Columns > Select both Homework A and HomeWorkB and then tap on Merge





it would look like this

Yes! That’s amazing - thank you!!!!