Fill out empty field with text strings in the previous row

Hello,  I'm working on a project involving application reviews, where each applicant (identified by a record ID) may have multiple rows of data. Some rows are missing the applicant's name. When the ...