From the course: Excel: Power Query (Get & Transform)

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Multiple tables

Multiple tables

From the course: Excel: Power Query (Get & Transform)

Start my 1-month free trial

Multiple tables

- [Instructor] Some mandatory fun was recently held and it was not fun at all but we aren't in trouble because we did go. We were cooperative. All right, we've got the three datasets here that need to be swept together into one place so that we have a big list of who participated. We've got session one, session two, and then the Cascadia location just sent a list of the people who attended. We don't care about which session that they went to. But some things to notice, obviously the three tables don't all have the same number of columns. And then session and two they have a department column but a big thing to notice is between session two and the Cascadia list, the columns aren't in the same order. Session two has name, work location, and then manager. Cascadia has work location, name, and the manager. So let's see how to append these. All right, cursor in the dataset. Let's start making our queries. Data from table slash…

Contents