Fill In Column Based on Other Column Value without Blanks

Hello! In an excel sheet, I have made individual rows that includes a name and have entered a 1 in columns C-I when the corresponding name is in office that day. For example, A2- Resident 1 B2- 1 C2...