How do you merge multiple columns and then expand them into a different arrangement using Google Sheets? Using a working example I will demonstrate how to migrate a specific data set containing columns, into a different data set using a different … [Read more...] about Google Sheets QUERY: Merge Multiple Columns & Expand Into New Structure (Example)
If there's one application I have come to appreciate more and more throughout my career it's the humble spreadsheet. Without this application, I would be lost.
I use this type of software every day and have been using it since 1995 and Microsoft Excel .
However, since working with Google Apps more frequently I've found I tend to do a lot more work with Google Sheets at work than Microsoft Excel. I have found the sharing and collaboration feature with Google Sheets a handy and powerful feature.
How do you apply the sum to a certain number of cells according to another input cell? The SUM function works amazingly well when the range sought for its total value is static, and one way of making a SUM function somewhat dynamic is to make the … [Read more...] about How To Sum A Dynamic Range: Google Sheets (Example)
If you are testing the return value of a function in the immediate window in VBA and get the following error: Wrong number of arguments or invalid property assignment (Error 450) What you are doing is something like this: Then in the … [Read more...] about How To Fix “Invalid Property Assignment (Error 450)”
Perhaps the easiest way to assign a default value to a variable is to append the || conditional after referencing the variable. For example, after looping through an array and mapping the values to properties within an object, I needed to test … [Read more...] about Google Apps Script: Set Value Of Blank Cell
Recently, I had to merge two columns into only one column on a spreadsheet. The way I found to do this was by using the following common spreadsheet functions: JOIN, TRANSPOSE and SPLIT, and if needed UNIQUE. I was able to find a solution, and … [Read more...] about How To Merge Two Columns Into One (Google Sheets)