Power Query - Dataflow - get rid of duplicate entries/ values in "Group by" function

I have a column that I grouped by tracking number. I want to display how many items in the shipments went to each student. 
I had a column that had the shipped dates so when I grouped by tracking date, I got duplicate dates I didn't need.

***Note: I changed my date field to a text column in another step. I was doing something else with the data, like using power automate to write the outputs to a CSV and I didn't want to deal with the whole "Format Date and Time" in Power automate.             ++

Here's the cheat FX:

{"WhatYouWantToNameYourColumn", each Text.Combine(List.Distinct([YourColumnName])," "), type nullable text}

Turns this:

Into This!

 

So later I could do this. :)

Blog Type: