ID records generate dupes for multiple locations

[rogerzebra]

Hi All,
This should be so simple but I'm to tired to think. I have a list of ID's that contains classes and some of the ID's has multiple location. For these that has multiple locations I get dupes. Please help me out here I'm so I can't see the screen Thanks in advance

 

[rogerzebra]

I need to clarify I can see that.
So, each ID has multiple classes such as
1001 has class 10,11
1002 has class 10, 23

So when I add the location to the query I get something like this
1001 class 10,11 location IL
1002 class 10 location IL
1002 class 10 location PA
1002 class 23 location IL
1002 class 23 location PA

instead of
1001 class 10,11 location IL
1002 class 10,23 location IL,PA

It is frustrating to not be able to solve this on my own, believe me. I'm just to tired for this cr#* at this point.
Thanks for all help.