I work for a financial firm as a data analyst and I am attempting to scrub datasets in order to enrich our contact list. An ideal world I am looking for a function or workaround to mimic the text join function that exists in Excel but in CRMA.
Dataset before it is scrubbed:
Column A: "(123) 456-7890"
Column B: Null
Column C: "(098) 321-4321"
Ideal State: "(123) 456-7890 | (098) 321-4321"
Currently, the formulas I have used error out when there are nulls.
I have used concatenate but it does not allow me to insert a delimiter and to ignore nulls.
7 réponses
