Merge or Split lists
Combine the values located in multiple columns into a single column.
Sometimes, you need to combine three or more list of values into one.
Sometimes, you want to combine two list values into a single one.
Having two lists with the same type of repetitive values, we will create a list containing only distinct values.
Having two lists with the same type of duplicate values, create a list of them, containing only unique values.
If the original list contains both text and numbers, then using array formulas in a single list to select all text values, and the other is numeric.