I've attached a workbook which illustrates what I'd like to do.
The workbook will have a range of 5 columns in which only one column will be populated with some letters, while the other columns will be empty (with a ""). I want the 6th column to look to the left and find the column which has letters in it, and then populate itself with those letters.
I know I could do this with a long nested IF formula but I'm wondering if there's more efficient formula to do this.
Any suggestions? Thanks!
Bookmarks