Good Afternoon -

I have a worksheet with 20,000+ rows-

The first column is a unique identifier for a group, and then the rest of
the columns B - M are services. What I need to do is merge the roles so that
if any listing of the 'group' in column A has something in any column B - M
it will show all listed. I will show an example below because I know it
sounds more confusing then it is...
This is how the data is

Group Red Service Green Service Blue Service Purple Service
1 Red Blue
1 Green
1 Red
2 Red
2
Purple
3 Green
4 Green Blue
4 Red

And this is how I would love it to be -

Group Red Service Green Service Blue Service
Purple Service
1 Red Green Blue
2 Red
Purple
3 Green
4 Red Green Blue