Google Sheets - Denormalize Data to Simulate SQL Joins

This video will show how to simulate the SQL JOIN clause in the Google Sheets QUERY() function using the custom function DENORMALIZE(). I am sharing the completed spreadsheet model so you can make a copy for yourself

Please like and comment if you have any questions.

Denormalize Google Sheet
https://docs.google.com/spreadsheets/d/1vziuF8gQcsOxTLEtlcU2cgTAYL1eIaaMTAoIrAS7mnE/edit?usp=sharing

Normalizing Databases
https://learn.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description

SQL JOINs
https://www.w3schools.com/sql/sql_join.asp

Custom Functions in Google Sheets
https://developers.google.com/apps-script/guides/sheets/functions

Getting Started with JSDoc 3
https://jsdoc.app
https://jsdoc.app/about-getting-started.html
https://jsdoc.app/tags-param.html

GNU General Public License
http://www.gnu.org/licenses/gpl.html