Hi
I am trying to consolidate mailing address fields and I would like to be able to concatenate Mailing Line 1 and Mailing Line 2 but with a carriage return as the separator. Does anyone know if this is possible? I could not find a way to do it and worked around it by exporting to excel but I love the Prep Tool and would love to be able to do all my manipulations within the tool.
Thanks!