From the course: Excel: Power Query for Beginners

Unlock the full course today

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

Filtering and sorting data

Filtering and sorting data

- [Tutor] Often data will come to you with rows that you just don't need. For example, down at row 50, you can see we have some test entry rows here that won't be helpful when we're analyzing this data. And then also down at around row 100 we've got these N/As here. So we're going to use power query and remove these rows. So scroll back up to the top here and you want to make sure the queries pane is open on the right. If it's not open, go ahead and go on over to the data tab, click queries and connections or click show queries if you have an earlier version of Excel. And to clean up this data, I'm going to right click and then choose edit. Okay, great. So let's remove those problematic rows that we don't want to include in the dataset. I'll go ahead and go over here to let's say the contact name and sure enough, there's our NAs. We'll remove those rows and we'll also remove the test entry rows, and that…

Contents