Excel Sort Same Values In Two Columns Easily

Sorting data in Excel can be a daunting task, especially when dealing with multiple columns. However, with the right techniques, you can easily sort same values in two columns. In this article, we will explore the various methods to sort same values in two columns in Excel.

Why Sort Same Values in Two Columns?

Sorting same values in two columns is useful in various scenarios, such as:

• Identifying duplicates or identical values in two columns
• Merging data from two columns into one
• Removing duplicates or redundant data
• Analyzing data patterns and trends

Method 1: Using the Sort Function

To sort same values in two columns using the Sort function, follow these steps:

1. Select the entire data range, including headers.
2. Go to the "Data" tab in the ribbon.
3. Click on the "Sort" button in the "Data Tools" group.
4. In the Sort dialog box, select the first column you want to sort.
5. Click on the "Add Level" button.
6. Select the second column you want to sort.
7. Choose the sort order (A to Z or Z to A).
8. Click "OK" to apply the sort.

Using Multiple Columns

To sort same values in multiple columns, follow these steps:

1. Select the entire data range, including headers.
2. Go to the "Data" tab in the ribbon.
3. Click on the "Sort" button in the "Data Tools" group.
4. In the Sort dialog box, select the first column you want to sort.
5. Click on the "Add Level" button.
6. Select the second column you want to sort.
7. Repeat steps 5-6 for each additional column you want to sort.
8. Choose the sort order (A to Z or Z to A) for each column.
9. Click "OK" to apply the sort.

Method 2: Using Formulas

To sort same values in two columns using formulas, follow these steps:

1. Create a new column next to the data range.
2. Enter the formula =A2&B2 in the new column, assuming the data is in columns A and B.
3. Copy the formula down to the rest of the cells in the new column.
4. Select the entire data range, including the new column.
5. Go to the "Data" tab in the ribbon.
6. Click on the "Sort" button in the "Data Tools" group.
7. In the Sort dialog box, select the new column as the sort column.
8. Choose the sort order (A to Z or Z to A).
9. Click "OK" to apply the sort.

Using the Concatenate Function

To sort same values in multiple columns using the Concatenate function, follow these steps:

1. Create a new column next to the data range.
2. Enter the formula =CONCATENATE(A2, B2, C2) in the new column, assuming the data is in columns A, B, and C.
3. Copy the formula down to the rest of the cells in the new column.
4. Select the entire data range, including the new column.
5. Go to the "Data" tab in the ribbon.
6. Click on the "Sort" button in the "Data Tools" group.
7. In the Sort dialog box, select the new column as the sort column.
8. Choose the sort order (A to Z or Z to A).
9. Click "OK" to apply the sort.

Method 3: Using Power Query

To sort same values in two columns using Power Query, follow these steps:

1. Select the entire data range, including headers.
2. Go to the "Data" tab in the ribbon.
3. Click on the "From Table/Range" button in the "Get & Transform Data" group.
4. In the Power Query Editor, click on the "Add Column" tab.
5. Click on the "Custom Column" button.
6. Enter the formula = [Column1] & [Column2] in the formula bar, assuming the data is in columns A and B.
7. Click "OK" to create the new column.
8. Click on the "Sort" button in the "Home" tab.
9. Select the new column as the sort column.
10. Choose the sort order (A to Z or Z to A).
11. Click "OK" to apply the sort.

Using the Merge Columns Function

To sort same values in multiple columns using the Merge Columns function, follow these steps:

1. Select the entire data range, including headers.
2. Go to the "Data" tab in the ribbon.
3. Click on the "From Table/Range" button in the "Get & Transform Data" group.
4. In the Power Query Editor, click on the "Add Column" tab.
5. Click on the "Merge Columns" button.
6. Select the columns you want to merge, assuming the data is in columns A, B, and C.
7. Enter the formula = [Column1] & [Column2] & [Column3] in the formula bar.
8. Click "OK" to create the new column.
9. Click on the "Sort" button in the "Home" tab.
10. Select the new column as the sort column.
11. Choose the sort order (A to Z or Z to A).
12. Click "OK" to apply the sort.

Conclusion

Sorting same values in two columns in Excel can be a simple task using various methods, including the Sort function, formulas, and Power Query. By following the steps outlined in this article, you can easily sort same values in two columns and make your data analysis more efficient.

Gallery of Excel Sort Columns

Excel Sort Columns Gallery

We hope this article has been helpful in sorting same values in two columns in Excel. If you have any questions or need further assistance, please leave a comment below.