Extracting all rows based on a value of cell

[MarkoGreenio]

Hi all,

Please advise of the title if incorrect.

I have a system generated report that produces a list of Employee names but the rows are interjected with other information. I would like the list of Employee names in one column, one after each other.
I have attached a Worksheet (sheet 1) which shows what I require and another sheet (My Effort), I gave it a go and tried an helper column but it only pulls one name.
The calculation I would like to see is in column N under the heading 'Job Title'.
I hope I have included all the information.
Many thanks in advance.

Mark
Note: the information is not GDPR sensitive (made up names)

[MarkoGreenio]

PLease could someone how I donate to the site, its been a great help to me lately

[MarkoGreenio]

Ignore last post, I have purchased some credit...thank you

[AliGW]

Closed in favour of the Commercial Services thread.

If you do this again, please PM a mod or admin and ask them to close the thread in the free section - duplicate post rules apply here. Thanks.