Auto fill blank columns in a row

Hey all -

I have a list of people in a bunch of rows, with their superior in the column to the right. Some are further down the line in the org, so they have more managers and fill up more columns. Others have only 1 manager and only fill up the first column to the right of the name.

Is there any way to write an equation / code that autofills each row? I would need columns R-V (everyone has Q filled with the CEO) to be filled with the previous cell in the row if R, S, T, U, or V is blank. If they are all blank, I would want them to fill with the same name as column Q.

I've attached an example of what I have vs what i Need, for your reference.

Thnaks!
-EN