Concatenate notes, based on adjoining cell reference without VBA

Hi Guys

I need to creat a simple worksheet output for notes that feed of a CRM system we use at work.

I've attached the speadsheet of the report as it generates in excel, and on tab 2, I've included an example of how I'd like the data to appear.

Is there a way to get excel to 'lookup' the cell references without VBA, and concatenate the notes of an issue?

Thanks in advance.