I have the following data in excel:

[![enter image description here](https://i.stack.imgur.com/Xor5x.png)](https://i.stack.imgur.com/Xor5x.png)

I want to group this data by the PartnerNumber like shown below:

[![enter image description here](https://i.stack.imgur.com/1WWtn.png)](https://i.stack.imgur.com/1WWtn.png)

I attempted to use PowerQuery by grouping by PartnerNumber, but it returns an error every time. Is there any way to group by the VendorNumber with a comma separating all the values?

I'm ok with doing it via Excel or PowerQuery, either way is fine.