How to fill blank cells in Google Sheets QUERY pivot
The QUERY function in Google Sheets has a pivot method, which allows you to create a pivot table. There will be times where your output produces blank cells. This video will teach you how to replace those blanks with a zero.
Timestamps
2:28: Create the header row
4:07: Isolate our dimension columns
8:45: Isolate our metric columns
10:12: Introducing the "N" function
11:26: Add zeros to our metric columns
12:43: Bring it all together
14:49: Full demonstration from scratch
My channel focuses creating lessons to help people learn how to work with data. The intention of these videos is to explain the fundamentals so that you can build data projects.
The main goal of this series is to get viewers to a point where they can attempt my beginner dashboard build. You can find a link to it here: • How to build a dashboard with dynamic...
You can also check out the playlist for this series here: • Google Sheets Dashboard Tutorial No. 1
If you're interested in ways to lookup data then you can find it here: • How to lookup data in spreadsheets
If you're interested in learning about the most powerful function in Google Sheets then you can find it here: • How to use QUERY in Google Sheets
Here is a sample set of data you can use to follow along with the lesson. Please make a copy and add to your Google Drive: https://docs.google.com/spreadsheets/...