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.