Skip to content

Instantly share code, notes, and snippets.

@kjola8
kjola8 / survey-cleaner.gs
Last active February 8, 2017 17:41 — forked from scytacki/survey-cleaner.gs
Google Spreadsheet script to convert survey answers to numbers.
/*
The goal is to identify each column for the type that is
and then convert the cells to numbers.
To identify it, we need to ignore the first few rows which will be headers.We could probably be safe and just skip the first
4 rows and start there.
*/
function getUnique_(values) {
var o = {}, a = [], i, e;