I have five columns with text values. I need to combine those, but add seperators between.
I tried (A..E represent column names)
Code: Select all
A+ (IF(B!="",","+ B))+ (IF(C!="",","+ C))+ (IF(D!="",","+ D))+ (IF(E!="",","+ E))
I have seen, that a SPLIT command exists - but is there a similar thing for COMBINE / MERGE?
Oh, if there is not, may be this could be introduced?
Thanks already
Olaf