PQ - Return unique values in row based table

(question from the web)

Quote:

---

Not sure if my Title makes sense, but I'm not sure how else to explain it. I am looking to take the first table (Column A and B) and convert it to return unique values for each unique value in column A. Below is an example and what I am looking the out.

Data I currently have (real data is 50k+ rows)
ABC 123
ABC 123
ABC 456
ABC 789
DEF 123
DEF 123
DEF 789
GHI 1010
GHI 1010

Outcome I am looking to get:
ABC 123 456 789
DEF 123 789
GHI 1010

What is the best approach to do this? I appreciate the help and thank you in advance.

---

ColA	ColB		ColA	ColB
ABC	123		ABC	123 456 789
ABC	123		DEF	123 789
ABC	456		GHI	1010
ABC	789
DEF	123
DEF	123
DEF	789
GHI	1010
GHI	1010

Code:

---

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Group = Table.Group(Source, {"ColA"}, {{"Count", each _, type table}}),
    List = Table.AddColumn(Group, "ColB", each List.Distinct([Count][ColB])),
    Extract = Table.TransformColumns(List, {"ColB", each Text.Combine(List.Transform(_, Text.From), " "), type text})
in
    Extract

---

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://eileenslounge.com/viewtopic.php?p=320960#p320960
https://eileenslounge.com/viewtopic.php?p=320957#p3209573
https://eileenslounge.com/viewtopic.php?p=318868#p318868
https://eileenslounge.com/viewtopic.php?p=318311#p318311
https://eileenslounge.com/viewtopic.php?p=318302#p318302
https://eileenslounge.com/viewtopic.php?p=317704#p317704
https://eileenslounge.com/viewtopic.php?p=317704#p317704
https://eileenslounge.com/viewtopic.php?p=317857#p317857
https://eileenslounge.com/viewtopic.php?p=317541#p317541
https://eileenslounge.com/viewtopic.php?p=317520#p317520
https://eileenslounge.com/viewtopic.php?p=317510#p317510
https://eileenslounge.com/viewtopic.php?p=317547#p317547
https://eileenslounge.com/viewtopic.php?p=317573#p317573
https://eileenslounge.com/viewtopic.php?p=317574#p317574
https://eileenslounge.com/viewtopic.php?p=317582#p317582
https://eileenslounge.com/viewtopic.php?p=317583#p317583
https://eileenslounge.com/viewtopic.php?p=317605#p317605
https://eileenslounge.com/viewtopic.php?p=316935#p316935
https://eileenslounge.com/viewtopic.php?p=317030#p317030
https://eileenslounge.com/viewtopic.php?p=317030#p317030
https://eileenslounge.com/viewtopic.php?p=317014#p317014
https://eileenslounge.com/viewtopic.php?p=316940#p316940
https://eileenslounge.com/viewtopic.php?p=316927#p316927
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA