I have a dataset which has a seven possible conditions based on data in other columns. I had to split my formulae for those conditions across seven different columns. I would like to combine all seven of those condition columns into a single column.
Col A Col B Col C Col D Col E Col F Col G result case1 case1 case5 case5 case2 case2 case6 case6 case1 case1 case4 case4 case3 case3 case6 case6 case7 case7 case4 case4 case3 case3
There will NEVER be a case where there are two values assigned to the same row. I just want to get the ONE data value that occurs in that row to show up in a single column. I could do
if(a<>" ",a,if(b<>" ",b,etc... but I'm looking for something simple and elegant. The best I've been able to come up with so far is
TRIM(CONCATENATE(A+B+C+D+E+F+G)) but I was wondering if there were a simpler function (like
MERGEALLCOLUMNSINTOONE(A:G) that would do this?