Google Sheets QUERY: Merge Multiple Columns & Expand Into New Structure (Example)
Merge multi-columned data to one column before expanding it out into a different columned layout using the QUERY and ARRAYFORMULA functions in Google Sheets.
Spreadsheets
How To Sum A Dynamic Range: Google Sheets (Example)
How do you calculate the sum of values across columns when the length of the range of those columns is dynamic? Use the INDEX function, as demonstrated in this post.
How To Fix “Invalid Property Assignment (Error 450)”
What happens when you get the oblique error from Excel VBA that there has been an invalid property assignment (Error 450)? Here’s how I was able to find the solution.
How To Assign A Blank Cell To A Default Value
How can you easily check if a Google Sheet cell has a value, and if it doesn’t to set a default value when assigning it to a variable in Google App Script?
How To Join Multiple Columns Into 1 Sorted Unique Column
Continuing to advance my feature previously on combining two columns into one unique column, here we combine multiple columns into one unique sorted column in Google Sheets.
How To Merge Two Columns Into One (Google Sheets)
If you need to join two columns of unknown height together then follow this step-by-step illustrated guide.
