Filtering Sheet based on criteria - removing duplicates

I have a problem with a macro I found in the web. I'm fairly new to macro coding and would really appreciate all the help I can get. I was able to run the macro and I just need one more filtering.

Raw data looks like this:
GroupName GroupID SubGroup
Carol 101 Caroline
Carol 101 Caroline
Carol 101 Carl
Greg 102 Greg1
Greg 102 Greg1
Greg 102 Greg 1
Greg 102 Greg

I was able to filter to this:
GroupName GroupID SubGroup
Carol 101 Caroline / Caroline / Carl
Greg 102 Greg1 / Greg1 / Greg 1 / Greg

I would want to filter the SubGroup further to this:
GroupName GroupID SubGroup
Carol 101 Caroline / Carl
Greg 102 Greg1 / Greg 1 / Greg

-removing the duplicates in SubGroup column.

Please Help! Thanks!