needing to list data side-by-side

Hi Team, I have an excel spread sheet that lists student IDs in one column and parent email address in the next. For example, student 98567 will repeat because the next column will list the mother's...