I have columns of hours, but the users may enter in notes for the days they are off.
I'd like to be able to capture those "daily notes" into a new column, so only combine the columns that have text.

Bonus if it can reference which column the notes are in, if not that's not as prudent.

attached is a sample file and the expected results

Click image for larger version. 

Name:	DailyNotes.PNG 
Views:	13 
Size:	12.5 KB 
ID:	9417

DailyNotes.xlsx