Create an array based off values in another array - exclude blanks

I've got a list of employees with corresponding titles in one sheet. I need to transfer the cells that are not blank. I might be over thinking this, but I can't figure it out. I've tried macros and indexing formulas, but it does not update properly if I add another name to the list.

Using the attached sheet:

If value in column "B" is not blank then copy corresponding title to column "D," from there I can do a VLOOKUP to pull the employee's name over.