When you process an excel table, sometimes you may want to sort the rows by each column value in the row. This article will tell you how to implement it.
1. How To Sort Excel Rows By Column Values In The Row.
- Below is this example using data cells.
- What I want to do is to sort the first row of the above cell range in ascending order. Below are the steps.
- First, transpose the rows and columns of the above cell range to get the below cell range, you can read the article How To Transpose Rows And Columns In Excel Table to learn how to do it.
- Convert the above cell range to an excel table, you can read the article Excel Convert Table To Range Example And Vice Versa to learn more.
- Now you can sort column A or other columns in the above table by clicking the down arrow beside the column title item such as Sale Item.
- Then click the item Sort A to Z in the popup menu list, this will sort the cells of the column in ascending order.
- Select the sorted table and transpose the rows and columns of the table to get another cell range, you can read the article How To Transpose Rows And Columns In Excel Table to learn how to do it.
- Then you can find the row in the result cell range has been sorted in ascending order like below.
