How to distill results down to single instances in a new table

[Rosalind90]

This is a follow up to this solved question 

I originally asked how to return a result based on a step-by-step process. I got a great answer from @lbendlin, and have a new question:

I now need to take the results from "Group Status", and only have them displayed once, either in a new column, or having the column be simplified somehow. I have a feeling it involves keeping the self-referential aspect for "Groups" and maybe list.distinct or list.single, but I'm not sure where to go with that.

Here is the data I'm working with now (opens in a sheets file) 

Thanks!

[Rosalind90]

That works! Thanks again.

[lbendlin]

If you group by the Group Status field you need to indicate what to do with the other data.

[Rosalind90]

It may be best to have this be a second query, so the results can go to another table. That way all the data can be kept from the initial query. I hope that simplifies things. I've included a table of what I'm hoping to achieve in this result:

red	Measure coffee beans
blue	Grind coffee beans
green	Measure coffee beans
yellow	Add grounds to filter

[lbendlin · Accepted solution]

you can either group by "Groups" and "Group Status"  in Power Query , or you can opt to do that all in Power BI which will automatically group these for you.