[Realtchr]

I have a school database where student information is organized under a student ID. The problem I have is that some students have only one parent contact and others have multiple parents and multiple contacts. What I need to do is figure out a macro that will move the different parental contact information under one student ID by adding columns as in the example I've attached (sheet2). If there are different phone numbers then I need to show these (up to 4 different phone #'s are possible for each parent). I'm pretty new to macros and don't really know how to even begin. -TIA

[20_2_Many]

Hope this helps.
Your Student list would go into the Students sheet Col A: - M:
Then you run the Combine Contacts macro.
It will:
sort the Student IDs (Primary Sort) and Contact (Secondary Sort),
copy Student A-M to Contacts A-M,
Combine multiple contacts from Students into Contacts (Contact_2, Contact_3 - (Max of 4 for the layout) on Contact Sheet
Remove the Duplicate (multiple Row entries) Student IDs from Contact Sheet
Leaving a single contact row for each ID in Contact Sheet and Student Sheet untouched.

[Realtchr]

Wow, thank you so much!! It looks like this did exactly what I wanted. I especially like the way you broke down what you had the macro do. Now I need to get into the code a little bit to see how you did it. Thanks again!