Like a database query join, how to denormalise tabular data to create expanded rows, ideal for mail-merges and data imports.
Welcome to LifeStack We write clear, helpful and informative content to help you get the very best from technology. Find our most recent posts below, including articles, tutorials, snippets & links.
Tutorials
Clean Browser Cookies at Mac OS X log off
How to use a logoff script to clear authenticated web sessions on a Mac
Analysing Event Feedback with Forms & Sheets
Dynamically and professionally handle your event feedback, gathered with a google form, analysed with sheets.
Articles
Google Calendars on the Web
Displaying Google Calendar events on the web, with this simple diary banner for your site.
01 Sep 2018 ► Google, Coding, Javascript
Protecting Data with Google Drive
How to best protect and secure confidential data using Google Drive and Google Apps / G-Suite
Dealing with confidential information in schools
Using a simple traffic light system for categorising types of information commonly found in schools and the classroom.
Spreadsheet Functions
How to concatenate columns in a query
How to concatenate columns in a query and return the results.
Format values based on whether they appear in another column
How to use conditional formatting to highlight cells that appear in another list.
Filtering data quickly and easily using the QUERY Function
How to create simple ‘drop-down’ filters in sheets to easily and quickly filter an imported range of data rows.
Coding
Running a Basic Helpdesk with Google Sheets
Create a simple helpdesk and request ticketing solution with just forms and sheets.
Simple Bulk Emailing from Google Sheets
Send better looking emails to a bulk set of email addresses, straight from Google Sheets.
14 Dec 2017 ► Google, Sheet, Coding, Javascript
Showing Menus in Container-Bound Google App Scripts
How to show menus and sidebars configuration to write more flexible App Scripts.
13 Oct 2017 ► Google, Sheet, Javascript
Looking for something else? You can find everything in the archive, or by clicking on any tags. Or take a moment to read more about our vision, approach and philosophy!