Merge variable rows into one cell

Question

I have the following data

and I would like to have it organized by individual parts while merging the parts IDs into a cell

is there any way of doing this with Google Sheets?

Answer 1

=JOIN(", "; TRANSPOSE(FILTER($B$2:$B; $A$2:$A = E2)))