From the course: Excel: Power Query (Get & Transform) (2020)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Combining table with different headers
From the course: Excel: Power Query (Get & Transform) (2020)
Combining table with different headers
- [Instructor] Recently there was some mandatory fun, which was not fun. We saw that we were in trouble when the rolled out the 99-cent hotdogs. But anyway, this is gon' be better than that. We've got the two datasets. We want to stack them up to see who did cooperate and showed up for the mandatory fun. But we've got an issue here. Notice Department and D-E-P-T. Those need to be lined up, but what happens when we append and those don't match? Let's do it. With our cursor in the dataset. Data from table/range, you know how it works. Here's our list one query, close and load. We're going to close and load it as a connection. Only create connection, okay. Then we need our list two query from table/range. List two. Now rather than going back into the worksheet, I'm going to stay in power query to do this append. I'm going to combine append queries, append queries as new because I want a third, final query as…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.