课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Unpivot and fill-down

Unpivot and fill-down - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

开始一个月试用 购买团队方案

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…

内容