From the course: Data Wrangling in Excel with Power Query

Unlock the full course today

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

Creating a flat table from multiple data sources to see everything at once

Creating a flat table from multiple data sources to see everything at once - Microsoft Excel Tutorial

From the course: Data Wrangling in Excel with Power Query

Start my 1-month free trial Buy for my team

Creating a flat table from multiple data sources to see everything at once

“

All right, everyone. So before we get started, what I would like to do is show you the data sets we're going to be working with. So if you go into module three, merging data, you'll see there's a folder here called data, and that's in your download files. There's two different data files here. So one is a CSV comma separated value file. That's kind of the older style files, but also just kind of a lower storage file, right? Because it only stores the data and just comma separating it and then, you know, going to a new line, it probably has that information as well. Then the other thing is we have a products worksheet, so any of these could come from a system that could have come from a coworker. There are two different file types and they're organized just a little bit differently. But what we can see is with Power Query, we can merge them very easily. So I'm going to open up the products worksheet and I just want to show you the contents of this so that we understand the problem. So…

Contents