From the course: Excel: Tracking Data Easily and Efficiently

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Unpivot and fill-down

Unpivot and fill-down - Microsoft Excel Tutorial

From the course: Excel: Tracking Data Easily and Efficiently

Start my 1-month free trial Buy for my team

Unpivot and fill-down

“

- [Instructor] A lot of times when we are tracking data, we aren't the ones providing the source data. We get it from somewhere else, and it's not formatted for our needs. Right now, we would like to track the items, and we aren't so much concerned about the weeks. We really want to sort this data in a column with the biggest numbers up top and then descending down the column. And we're going to start with the data that ends in Row 12. And then the data in 16, 17, 18, 19, that's for later. Just hold on. So, we've got this source data in, Red three ounce in week one sold 10. How do we get this so that we can sort the numbers? My cursor is in a dataset. I'm going to right-click, Get Data from Table slash Range. Table does have headers. Okay. Now, I'm in Power Query with that Items column highlighted. Want to go up here, right-click. Unpivot Other Columns. Now watch this. You're going to see what happens when I…

Contents