Academy ↓
Hey there stranger!
Sign up to get access.
Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!
About this Tutorial
Sheet Resources
Featured Formulas
Video Transcript
In addition to backups, if you want to have extra information like from years past or something, maybe you have a database every year and now you're in 2020, or you're preparing for 2021 and you're like, oh, how do I grab 20 20, 20, 20 19, 20 18 data and put that all together? So here's. How I would do it.
Let's see if it works, because it's fun. We're gonna use some curly brackets. We're gonna create a settings page. It's gonna be really fun. So here's where we want, wanna put all data. We have a database one here. Now, if we had two sheets I could tell you exactly how to do that. You would just do equals you put in curly brackets.
Import range. Import range, not import range. And in import range, we're gonna have the spreadsheet url, something like. This can take the entire URL or just the id? We're gonna get the range, which is db. Nope. It's all, I think all and then exclamation point a. And then what we'd do is we would just combine these, right?
We would end this where is it? Here we go. We would end this, and then we would just do that all again for the next. Next one. Same exact thing, but we want to get from here. So let's look at that. And we also want to make this a lot less intense. Okay? So let's not do that. Let's do this. Let's make our lives a little easier.
We're gonna add a settings. I'm gonna call it settings. We're gonna go and this might work well too, abstract way. How, if you have a ton of different sheets, if you have 20 sheets for the last 20 years. So we're gonna do, let's do DB two. We're just gonna label that DB two.
We don't need all of these. Let me just quickly get rid of all of these. Things there. So we want URL in here, and then we want our SH here. Okay, so let's go here. I don't even want the entire url. I just want this. ID Really? Yeah, give me that id. It's called all, so I don't need to remember that. All A to B.
And then here we're gonna put the id. Okay. So we know we can label these. Absolutely. I'm just saving a little time here. We're just gonna have a label and now we can do DB three, DB four, as many as we want. But let's go back here. Let's do this equals, and we're gonna put in, actually, let's look at import range first.
What's gonna happen? I know what's gonna happen, but let's go walk through it. Settings U URL is B one and the range is settings. C one I missed something here. There we go. And so this is the exact same thing as in port range, except we are now abstracting a way that the information is over here, B one and B and C one.
And it gives us a reference and it says, allow access cuz we need to allow access to that sheet. That's cool. We're gonna do that. I'm gonna do that in a second. But let me show you what happens if we put this in a curly bracket already. We have not given access to it, and we're gonna try this. We're gonna try to add this here A to B to it.
So now we're gonna have two everything all in one, but it's gonna give us an error and this error is because we haven't yet given it access. So we, I'm gonna delete all of this stuff. So if you don't give it access it, you're gonna have errors. So just allow access and then we get truths, right? But we don't want just that.
We want everything. We want to add it. We wanna add in series import range. We're gonna ha use a semicolon here. If you have a different language setting, you might be different. And we're just gonna do DB one eight A. A no, A to B, that's what we're doing. And end curly bracket. And now we get a, we almost got another error.
Okay, we have this and then let me see how many, cuz we, I put the same name just so we would be able to tell. And now there's only one, there's two now. That was, there we go. So this one is false. And then I think this one is true, so we'll know if they're both on there. It's true and false. Okay, so let's go.
Is there only one? There's two one's true and one's false. There you go. So now we have all of our data from both sheets. The sheet that's on this, the tab that's on this sheet, and a sheet that's on a completely separate sheet, we've now combined them. With these curly brackets, import range, we have also created a settings tab that we can add many more.
We can add many more sheets here, and then we can create them in series, not create, smush them together in series here. And now we have a way to, combine all that data. We can sort it in another tab, we can say. Sort by name. We can get counts. We can start our data crunching and munging not munging crunching here, bite.
Topics
Courses
Better Than Happy | Redesign of The Feelings Wheel
How Starter Story Designs Data
Learn to Love Your Sheets
Best Header Font Ever
Sheet Review! 150 Active VCs by LemonIO
Anika Asks: How To Set Text Overflow All The Time
Introducing: Brutal Calendar
Add a Checkbox to Turn on Dark Mode
00:05:10
Create Drop Shadows! This makes your dashboards pretty.
00:12:04
Merge Cells for Dashboards
00:05:29
10 Things I Hate About Your Spreadsheets
Dark Mode / Better Font Color
00:09:35
Better Font Colors
00:02:45
Magical Things You Can do with Checkboxes in Google Sheets
00:12:31
How To Export Your Beautiful Sheets to PDF
00:04:06
Consider Labels as Opposed to Headers
00:04:02
Add Icons To Your Sheets With a Domain Name
00:04:21
How To Color Cell Blocks So Others Enter Data Easily
00:10:30
Great Sheets! Corona Hiring Sheet
00:10:43
Great Sheets! Community Information Board by Seedtable.com
00:07:35
Roast: Hotel PPC Channel Cost Calculator
00:11:25
Better Header Fonts - Best Fonts To Use In Google Sheets
Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell
00:09:49
Basic Keyboard Shortcuts To Speed Up Your Productivity
00:13:44
Basics - 5 Ways to Change Row Height
00:05:08
Anders Asks: Can I Highlight Whole Row if Certain Columns have text?
00:09:31
How to Refer to Other Cells - A1 and R1C1 Explained
00:13:22
Change the Default Font
00:03:33
Biggest Flaw In Dashboards with Dark Colors
00:07:45
Basics - 4 Ways to Change Column Width
00:05:48
Basics - Structure of a Sheet: Index() Row() and Column()
00:06:49
Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets
00:08:55
Use Cmd + Y To Do It Again, and Again, and Again
00:03:03
Create an Auto-Update Sales Chart: Trailing 12 Months
00:09:57
Google Sheet Basics - The Absolute Basics
00:09:48
Secure Your Sheets by BetterSheets.co
00:11:07
How To Create An AutoFill in Google Sheets
00:06:07
Build a Thermometer for Savings Goals
Make Your Lists Spicy Hot in Google Sheets
00:01:47
Restrict Access to a Cell if Another Cell is Blank
How to Use Smarket
00:03:28
Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!
00:06:23
Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!
00:53:31