Extract everything related to a name of a person

[Hen201]

Hi,

I'm trying to export a list of everything associated to someones name. I have a sheet with all the raw data with many names and things associated but I want to see everything that has just "x" name without filtering. And then taking everything that's associated with "x" and seeing that on another sheet.

To explain a bit more, I have 1 blank sheet. They select their name from a drop down list and being able to see everything that's related to their name.

Using formula to try and present it neatly. Is this possible?

[torachan]

big yellow banner at top of page - instructions how to upload your workbook.
you may then get a solution to match your precise needs
torachan.

[Hen201]

Hi I can't upload as it's confidential data, sorry

[torachan]

its a simple case of help us,to help you.
we are not wanting your confidential data.
simply a sheet with a dozen row of desensitized data in the layout and format that you are dealing with.
From your description we are most unlikely going to construct a precise solution.