Duplicate Multiple Record Combine

[Pestomania]

Hi,

I am trying to combine duplicate records but keep the data. I will provide an example below.

Current Data:
Part# text
------------------------
Part1 Sentence 1
Part1 Sentence 2
Part1 Sentence 3

Desired Outcome:
Part # text
-------------------
Part1 Sentence 1, Sentence 2, Sentence 3

I am unsure of how to concatenate inside of a table.

I have two append queries building the table. And then a query that pulls from said table. But I need all text to be listed.