The attached file shows one student with 3 records. The two records in blue font are for the same class so include all of the same information except for Visit Length (Column L) and the other record is for a different course. I would like to merge the two records that are for the same class and sum the visit length (leave all other variables as is). So once the process is complete, the same student would show two total records only.
Bookmarks