Clay Icon

How to Combine Multiple Email Columns into One in a List

ยท
ยท

If I have a people list with different columns of data for emails, how do i combine it into one column

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You can combine different email columns into one column using the Merge Columns feature:1. Click "Add Column" then select "Merge columns" 2. Input a formula to combine your email columns Source: Hide, Re-order, Sort, Filter, Merge Columns

  • Avatar of Ravi P.
    Ravi P.
    ยท
    ยท

    i dont want to merge one column into another. Some people have their email in 'Column 1' others in 'Column 2' etc, whichever column its in, i want to create one column so all the emails are in one column

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You can use the Merge Columns feature to combine emails from different columns into a single column:1. Click "Add Column" 2. Select "Merge columns" 3. Input a formula that combines your email columnsFor example, if you have emails spread across "Column 1", "Column 2", and "Column 3", you can create a formula that takes the first non-empty email value from any of these columns. Source: Hide, Re-order, Sort, Filter, Merge Columns

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Ravi P.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: