Null vAlues and If statement

Hello I have a data export that is not the cleanest.  When Importing under the "name" column all the null values that are under Jessica Bayne, relate to her.  All the null values under Casey, those r...