Pull the first non-blank value from a range of cells in a row
I have a series of columns that will be filled with a project name (from a dropdown) depending on which column is filled out from my form. I want to have a sort of master list column, that will display the project name for any given row (since otherwise, the project name will be in different columns depending on which was filled out in the form).
What kind of formula can I use in this 'master' column to pull the value of any non-blank cell in a range of columns say 'A' through 'K' ? There will only be one project name per row, and it will be somewhere within those 11 columns, I'd like to pull out the name to one collective column.
Any help would be appreciated, and let me know if I need to clarify my objective further.
Help Article Resources
Check out the Formula Handbook template!