Excel query to find all matches of a cell and display all subsequent values

Excel query to find all matches of a cell and display all subsequent values

Cancelled

Job Description

I would like to find all the matches for the occurrence of an email and display it horizontally aginst the email address in Row A.
I have tried using the VLOOKUP function but the limitation is that if there are duplicate matches in the lookup column, only the first occurrence of the matching value is used.

Please see attached sheet and what is required.
Many thanks,

Priyanka

Open Attachment

Other open jobs by this client