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