Forum Discussion
Solved
Combining Columns with overlapping data
I have a table that has overlapping data. How can I create one merged column whereby if there are blanks in one it takes the value from the other and if there are blanks in the other it returns the v...
Hi,
just add a (conditional) column and create an if-statement kinda like: if [col1] = "" then [col2] else [col1]
Regards,
Julian
Hi,
Try this
=if [col1] = null then [col2] else [col1]
Hi,
just add a (conditional) column and create an if-statement kinda like: if [col1] = "" then [col2] else [col1]
Regards,
Julian