We will see in Google Sheets how to combine multiple columns into a single column with the array. We will also see how to get unique values with Unique function and sort them with the Sort function.
Here we have two columns with odd and even numbers in B and C.
In cell A2, we want to get unique values from both columns into one column A. we will insert the formula
=UNIQUE({A:A;B:B})
In Cell A2, we will select column B, semicolon (;), and column C. This will create a single column from both column values, but as we want unique values, we will add the Unique function to get unique values.
You can see the result in the following image.
It will result in Column B values first and Column C values second. To sort these values alphabetically we will use the Sort function.
=SORT(UNIQUE({A1:A10;B1:B10}))We will add the Sort function before the Unique and after is equal to (=). It will sort both columns into one, see in the following image.
You can watch our YouTube tutorial – how to combine two or more columns in one column in Google Sheets.
Transcript
Hello Guys,
We are going to see, how to combine two columns and get unique values.
Here we have two columns with odd and even numbers to get unique values from both of these columns I will insert the formula in A1. In A1 type = unique then open bracket and then curly bracket and then select the first column then add a semicolon, then select the second column then curly bracket then close bracket and press enter you can see we have got our unique value but these values sorted as column A and then Column B.
If you want to sort these values in alphabetic or numeric order we need to add another formula.
To sort, double-click on A1 and add Sort after = and before unique.
Now you can see all the unique values of the two columns.
If you want to know how to sort minimum to maximum or vice versa let me know.
if you like this feel free to like, share, and comment on this video, and don’t forget to subscribe and follow.
