If I have a people list with different columns of data for emails, how do i combine it into one column
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
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
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