Exporting data from a school database will produce student records on multiple lines, depending on how may parents/guardians a student has in the system. If a student has just one parent, only one row is created. If a student has two (or more) other parents, an additional row is created for each. All of the Student’s information on each row will be identical, but the fields for a parent will be different.
I want to merge rows with multiple parents and have all columns for each parent part of the same row (See attachment).
At most there could be 4 unique parent/guardians for each student.
Bookmarks