Returning values for duplicate references

Hi

I was wondering if anyone could help me. I have a spreadsheet (worksheet 1) with unique references on one side together with notes beside each reference.

I have a separate sheet (Duplicates) within the same workbook with duplicate references (which exist on worksheet 1) with notes beside them. Some of these duplicate references have different notes beside them.

What I would like to do is to return or bring across and have beside each other, both sets of notes for each duplicate reference in separate columns so that I can manually merge the notes into worksheet 1 to have a record which contains both sets of notes.

Does this make sense? I have a copy attached to show what I aim to do.

Does anyone know a formula which would enable me to do this? This would be greatly appreciated.

Thank you.