Combining Duplicates (by row)

#1
Good morning,

I have a file that has duplicated cases with both missing and different variable information. My file looks something like this:

ID Sex School Grade Age Race
1234 F Wilson 8 11 Black
1234 Wilson 11 Black
4321 M Matthew 5
4321 M 5 15 White
3287 F Lincoln 8 13 Hispanic
3287 M Socrates 8 13 Hispanic


How can I merge/combine the duplicates to create one row of data? I also need to create additional variables where there are two different entries (e.g. for ID # 3287, the School reads Lincoln in one instance and Socrates in another).

Thank you!

Stephanie