Adding custom columns using List.Distinct

[danhendo888]

https://1drv.ms/x/s!AvjBsEPEq12ngSB0nBRb6FOkOLJz?e=Jfo3wo

Hey guys,

I am trying to reduce my first table (where I have my data) into the desired output which shows information for unique values in Column C.

In Power Query, I have Grouped By the first four columns.
In the Group By popup menu, I have added one column which does COUNT

After that, I am using this formula on ADD CUSTOM COLUMN option to show unique list for each other column (from Column E to Column K)

i.e.
List.Distinct(Table.Column([Count], "Creation Date"))
List.Distinct(Table.Column([Count], "PO VAT Amount"))
List.Distinct(Table.Column([Count], "Total PO Amount"))
and so on.

But I am doing this one at a time for each column.
Is there a quicker way to do this or does it have to be done individually?

And for the invoice highlighted in orange. How do I make it so that I don't get this result:
https://imgur.com/a/4kTzM29
That is, if there are values in Columns I to Columns K for an invoice, I do not need the other rows for that particular invoice.

 

[danhendo888]

https://1drv.ms/x/s!AvjBsEPEq12ngSB0nBRb6FOkOLJz?e=Jfo3wo

And for the invoice highlighted in orange. How do I make it so that I don't get this result:
https://imgur.com/a/4kTzM29
That is, if there are values in Columns I to Columns K for an invoice, I do not need the other rows for that particular invoice.

For this question, I suppose I could create a copy of the table in a new query and then merge them with Left.Outer for values in Columns I to K?
If my second table had two columns where the first column was the Order Ref. Then the merge would produce values in the second column.
How would I do it when I need to lookup values for more columns? Is there a short way or do have to do this one by one?
I.e. create three different table with two columns where the second columns are made of values in Columns I to K, respectively