Today i am presented with thousand entries of data and i am interested in presenting information based on the content of two columns in this nature.
This is like pulling first name and surname stuff only i am doing a conditional concatenation of the source data from two different sources.
Column 1 Column 2
And the logic is if Column 2 has a comma -> content after C should be substituted for content in Column 1 after the forward slash "/"
let column1 be C5,C6....
and column 2 be D5,D6.....
trim is put in to eliminate any white space that may occur.
This formula does it, constraint column 1 must always have a "/" present, however a logic case can be built like as applies to column 2 to take care of the absence or presence of a "/" in column 1.