Essentially, I want to create a Master_Supervisor_List and Master_Employee_List. Essentialy my columns go from "Supervisor AH" all the way to "Business Title ZH". I cannot reorganize the columns because the survey is built using logic. The columns repeat in the following order: Supervisor, Employees, Buisness Title.
In otherwords, each row will only ever have 3 values present in the following column range of "Supervisor AH" to "Business Title ZH".
How do I write a formula that would return the Employee present in the row and Supervisor Present in the row?
