Excel Power Query Grouping list

It's almost there but not quite , I'd got this far after a bit more thought, the problem is if you look , Gigi appears twice in the who sold what, as we're combining two unique lists,
we need to combine and then make unique, I've got the number of steps down and I've attached my updated version,

I only started this to refresh my memory on grouping things.

Richard.

I've just had a look at the attached workbook, and in power query there is , I don't know how else to explain it,
I have grouped by total sales , so for the tied 2nd position I have to lists, which means that when I use

Please Login or Register  to view this content.

What is returend;

Please Login or Register  to view this content.

What I would like ;

Please Login or Register  to view this content.

This problem only occurs for the tied position,

Hi, I'm reposting this question, and I've tried to make the problem clearer, with a new work book,

The problem remains the same I have grouped data where there is a tie, and want to extract the values from the 'groped ' 'All Rows',

I've made a copy of each query as I've added each step and named them as to what they are trying to achieve,

the last query has a list of names, but there are duplicates, this is what I'm trying to get rid of I only want a disctinct list of the names.


Richard

I was thinkin of trying List.union, i've not used it , but I've seen it used in a similar situation. I have to go out today but if I get it working I' l update post.

Richard.

Thanks for the help ;

used ;

Please Login or Register  to view this content.

I've attached stripped down version so can be seen in context,

Richard