From the course: Excel: Power Query (Get & Transform)
Join today to access over 23,100 courses taught by industry experts.
Multiple tables - Microsoft Excel Tutorial
From the course: Excel: Power Query (Get & Transform)
Multiple tables
Let's talk about getting multiple datasets all stacked up so that we can do analysis, summaries, whatever we need. But we have to get the data in one big stack. Let's look at our data. We've got store inventory and Warehouse 1 inventory. And on Sheet 2, we have Warehouse 2 inventory. Now this one has brand, phone, and contact. Scroll down. Okay. And then let's go back to Sheet 1. One thing we might want to do. How many of each paint do we have by size? And we don't care about the brand or the contact information. And notice, we have indigo, 8 ounce in the store inventory where we have 7. And over in the Warehouse 1 data, we have four and one eight indigo from AJ&JJ supplies. Let's look over here. We've got four eight-ounce indigos here from Wavelength Paints. Scroll down. This inventory doesn't have an eight-ounce indigo for A.J&JJ supplies. But that's the kind of thing we want to do, get everything all stacked up so that then we can start getting these summaries and make this data…
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.