课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

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

Append in Power Query

Append in Power Query - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

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

Append in Power Query

“

- [Instructor] Okay, we have data that needs to be stacked up, and it's in three different places. This happens a lot when we have to track data, maybe we need to maintain one big main list with certain people in it, so that it's easier when we need to look at it. Who's in city center? Who's in River West? Where is Boris or Ned? Who are their managers? If this data is all in one place, we can easily sort, filter or get counts of who's in what location or region, or how many people are under a specific manager. Okay, we got to get this in one place, and I'm going to show you how to append, not copy and paste. And also, let me remind you, I do have a "Power Query" course where I go into Append deeper and a lot of other neat Power Query features. So please, please check that course out for more of this kind of thing. So here, let's look at our data. We've got Southeast, and we have these columns: Name…

内容