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
Category: Web Stuff
Everything done on the web that is entirely unrelated to WordPress.
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
Set as “Not Junk” On Shared Mailbox In Outlook
How to set email senders as “Never Block This Sender” and create Rules for a Shared Mailbox that you have been granted access to.
Posted on 31/08/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
