needing to list data side-by-side

Copper Contributor

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 
I need
Much appreciated if anyone can help.

1 Reply

How about this?