Concatenate notes, based on adjoining cell reference without VBA

[icapo]

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.

[darkyam]

So far as I'm aware, no, there is no formula that can access notes in a cell.

[icapo]

Thanks for the reply.

In that case, is there a VBA script which would let me do what I'm trying to achieve, and how would I go about using it?

Sorry, I'm a bit of an excel novice