Forum Discussion
Solved
merging columns with rules
How can I merge two columns into new column (col C) where if col A and B are equal then it should only give me the value of what is first column. If they are not equal then merge two columns togethe...
You could add this as a new calculated column:
Col C = IF ( [Col A] = [Col B], [Col A], [Col A] & [Col B] )
You could add this as a new calculated column:
Col C = IF ( [Col A] = [Col B], [Col A], [Col A] & [Col B] )
jdbuchanan71 Thank you, that worked!