I�??m trying to do this now, and I am concatenating, problem is that not all the fields have values and I end up with leading/trailing spaces or double spaces. How can I get it to concatenate but skip over the empty fields? Small sample set attached.
... View more