I'm trying to set up a school technology inventory spreadsheet using google forms. Here's the spreadsheet.
The header columns are:
A timestamp B name C room
The data columns are:
D Device E School ID# F Asset# G Serial# H Notes
The form repeats this 10 times (as each class has multiple devices), so
J Device K School ID# L Asset# M Serial# N Notes
P Device Q School ID# R Asset# S Serial# T Notes
are also data columns - up to:
BF Device BG School ID# BH Asset# BI Serial# BJ Notes
We need each device in its own row, with header info in columns A-C and device specific info in rows D-H.
This excellent question and response is nearly exactly what I need, but the formulas seem to derail over the "Notes" data and "dividing by 0". I've been messing with it for a few hours and could use a hand.