I'm trying to concatenate 15+ columns into one and have the results appear in
list format- so I've used =concatenate(a1,char(10),a2,char(10),a3.....
function. Wrap text is enabled. However, some source columns contain blanks
and I don't want a blank row showing (it will make my row height huge!) and
make the list look odd with big blank spaces. Any ideas?