How do you merge multiple columns into one column in Google Sheets using the QUERY function? In this 4 simple step-by-step process we share the formula, and teach you along the way on how component within the function works by providing commentary and photos at each change.
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.
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.
What’s the best way to install NodeJS on your Mac machine? In this article I briefly go through the steps of how I installed NodeJS on my recently nuked Macbook Pro.
If you’ve done work from the Google App Script Editor, but need that extra development environment to help you code, then there’s a great module you can install from npm that will help you edit and push your edits from your computer to your Google App Script code in the cloud. This has the added benefit of also being able to apply git to your code if you need to push your code to your organisation’s repository.
If you’re trying to get Bootstrap (version 2.0.2) to work with the new ExpressJS (version 3.0.0) there are a few steps I have found required to get it to work. Here’s what has worked for me.
If you use the excellent WebStorm (or any of the other great IDE’s from JetBrains) to code your SuiteScript, then you’ll want to add the SuiteScript plugin to be able to deploy your code into your NetSuite instance.
There are several excellent coding editors for SuiteScript programmers to choose from, especially if you’re not too fond of the Eclipse IDE which is the recommended tool of choice within the SuiteScript help documents. In this article I explore other editors and share my personal preference.
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.
If you have a page hosted on Github Pages using Jekyll there are times when a little character in the wrong place can cause the whole site or page to crash. Here is a list of gotchas I’ve encountered and how to prevent them from happening again.