Dynamically fill rows

[davidogundipe]

Hello, relatively new to Alteryx and wanted to know if it was possible to dynamically fill rows with data? I have a spreadsheet (attached) and I want to assign senior managers to staff. As it is right now, if a staff has anything other than an actual client (e.g. apple, google, microsoft) in the engagement name, like vacation, then a senior manager won't be assigned to them. I would like to fill the SM column for rows that say vacation with the senior managers that the staff are assigned to. 

I know it's hard to understand via writing, so I attached an example of my current state and my desired state in the spreadsheet. Please let me know if you can help!

[apathetichell]

Something like this?

I filtered out the vacation entries and then self-joined on employee name dropping the original senior manager information and replacing it with the non-null/vacation version.