Sort Query Results to remove duplicate entries and put results on one line.

Hello and Thank you in advance.

I wrote a vba script that runs an SQL query that gives me a list of all the parts we have in stock and where they are located. I need to be able to sort them so that a part is only listed once and all the locations are listed on that row next to the part number. Sometimes there is only one location. Sometimes, there are up to 26 locations.

My main approach was to sort the parts in order and use a for loop to check for matches and to use relative references to move the found locations up, but I haven't been able to get that to work.

I've tried everything I can think of and I'm getting no where. I've attached what a sample parts list would look like (sheet1) and how I need to have it sorted (sheet2). I'm not asking for anyone to write this for me. I just need some advice as to what direction I need to head in.

Thank you for your time and consideration.