Thulani Zulu is not in your Original sheet.

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.