From the course: Excel: Managing and Analyzing Data

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Sort in Power Query

Sort in Power Query - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Sort in Power Query

“

- [Instructor] When you're in power query, you don't get the sort options that you get on a worksheet. You can't sort left to right, you can't sort by a sale color. So let's take a look. I have all of this car data, the style, the transmission type, the color, mileage, and the year of the car's make. Right click and get data from table slash range. The data is now in power query, and you can see the sort options are sort ascending or descending. That's it. We can sort by levels, but we have to think forward and be very deliberate about how we do it. So in this situation, we want to sort the transmission so that manual is on top of automatic, and then we want to sort by the style and then the mileage. I'm going to click on transmission. And because we want manual on top, we're going to have to sort this descending. There we go, Z to A. Next, to sort by the style. Highlight the column A to Z. Now watch, I'm going to…

Contents