Looking to extract data from two columns and putting them in a new sheet

Hi,

I'm having trouble figuring out a way where I can sort data which makes it a lot easier to read. So I have an example in the attachment data 1, and the finishing product in the attachment data 2. I have 2 columns of data. The first being the username/role. The second column being the role for these username/role. A role can be the username. So my dilemma is I want a formula or code where it can search each username in column 1 and the role in column 2. If the role in column 2 is also in column 1, but may be further down in the document, I want it to show each step. My explanation may be poor and I find it hard to describe but maybe the attachments will help explain what i am trying to achieve.

Thanks for your help.