Dear team! How I merge 4 email columns into 1 email column with a vali...

Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉

Great question, David! Using conditional formulas would be best for this, here's a quick video on how to use them/set them up - https://www.clay.com/learn/how-to-use-ai-formulasIn this case, you can add a new column and prompt it to return the values from each previous column with data like: first return /col1 then try /col2 ....

Let me know if you run into any issues!