excel Entering the values assigned to the object

I have to write a formula for a table, which would work like a Pivot Table. A Pivot Table won't help me though due to data updates.
6aHsk.png
This is a table that consists of 5 columns:"Part", "DY", "STATUS", "ALL DY", "LAST DY". Each comment from "DY" category has to be assigned to a row from the "Part" column. Table will be regularly updated and for sure repetition of "Parts" will occur, just with different comments in the "DY" column.I want "Parts" to be linked and "DY" comments to be saved into "ALL DY" column in form of:"First comment DY / Second comment DY" etc. and to add to that - the last DY comment should be placed in that part's "Last DY" column, separately. It's a similar mechanism to a Pivot Table.This is how this (manually filled) table should look like. This is the effect I want to achieve.
ends.PNG
Please note: the "STATUS" column doesn't matter here.