Nesting lookup values into text

Looking to find a way to update certain parts of destination text with different lookup values. For instance column A has five rows of the same unique ID, each corresponding value in column C is an attribute associated with value in A that I would like to nest into text in column D. . . . Example attached :/

follow my logic from the attached workbook, you should be able to use those formulas to come up with your own solution. Let me know if you have any questions.