Trying to change something that I have working with three columns of email addresses…
Now, I have four columns. Three always contain an email address. The 4th column only has an email address about 20% of the time. I CONCAT these columns into an “Added Column” with
I use a modal to have people type a few notes. The email addresses then POST to a ticket system we use to create Help Tickets.
But, it is an issue to have email, email, email, null
Is there a way to remove the ,null when the 4th column is null?