Click to View
This can be done in many ways why not directly in a Google Spreadsheet
Model for a script to unpivot data collected in a Google form
I hate downloading data from a Google form to CSV or Excel !
Why use Excel with VBA or Access or SQL.
The data should be manipulated directly in the Google spreadsheet (on a separate sheet)
Why use Excel with VBA or Access or SQL.
The data should be manipulated directly in the Google spreadsheet (on a separate sheet)
Mr Stillman (Andy!) that is why I was looking at:
Google Cloud SQL
Google Cloud SQL
I did come across this beast
There is a few commands in SQL that unpivots data.
Take a look at the following example (Click)
What shall I (we) call this Script !
