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 email address and then the father's email address. I need the parent email addresses side-by-side.
Instead of
98567 xxxatgmail.com
98567 yyyatgmail.com
I need
98567 xxxatgmail.com yyyatgmail.com
Much appreciated if anyone can help.
