is there a way to merge columns. For example, if I have a personal email, professional email of multiple contacts, I'd like to combine into 1 email, and in case there are 2 emails for 1 person, it would create 2 columns
Yes, you can merge columns in Clay. Here's how to do it:1. Click "Add Column" and then select "Merge columns"
2. Input a formula to combine the two columns you want to merge
Source:Hide, Re-order, Sort, Filter, Merge Columns