A simple solution for separating the values of a range with blank columns to allow easier merging of two columns.
IMPORTRANGE Separated By Blank Columns
Posted on 26/11/2025
Tag: Google
Everything from embedding Custom Google Searches to tip’s and tricks for using Google Search Console.
Or just changing the password to something you registered for using a Google account.
Get All Sheet Tab Names in Google Sheets
A simple bit of Apps Script you can use to get the names of all your tabs in Google Sheets.
Posted on 26/11/2025
How To Copy Conditional Formatting Between Google Sheets
A simple workaround to the annoying inability to copy conditional formatting between spreadsheets.
Posted on 25/09/2025
EventBrite via Google Sheets
How to create a Google Sheet which could retrieve various information about your own events and attendees using the EventBrite API.
Posted on 08/09/2025
Using Bookwhen API With Google Apps Script
A quick bit of Apps Script using the Bookwhen API in a Google Spreadsheet to list every event ever created by an account.
Posted on 06/06/2025
Fill Google Doc Template Using Sheet Apps Script
A bit of Google Apps Script that automates the process of generating personalized documents based on document templates using data stored in a spreadsheet.
Posted on 06/05/2025
Add Incremental Numbers Where Other Row is Not Blank
This is a simple bit of Google Sheets formula used to add a row of incremental number is row A where row B is not blank.
Posted on 25/02/2025
Lock Google Docs On Shared Drives
Here’s a simple bit of Google Apps Script for locking a document (effectively making the document read-only).
Posted on 28/01/2025
Replace Links With URL In Active Google Sheet
A simple bit of Google Apps Script that converts all links within an active Google Sheet into full URL links instead.
Posted on 28/01/2025
Get Last Row in A Column Using Google Apps Script
Another simple bit of code that’s worth writing down: how to get the last row in a specific column using Google Apps Script.
Posted on 08/12/2024
