I have a job satisfaction dataset/spreadsheet that I am working with. I have a number of cells with values of 0 (zero) which indicate questions that were not answered by the participant. Ultimately, I need to convert those zeros to the average of all other answers from that user. I have created a new column that averages their answers but without going one-by-one and manually plugging the answer into any missing cells for that user, I don't know of a faster way. So ultimately, each user has an average score (column AVERAGE) based on 36 questions. I need to take the value from the AVERAGE column and auto-populate any zeros for that user (because each user will have a different AVERAGE score). Is there a way to do this using a formula?