With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
user Stephen Dishman said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/how-do-i/desktop/-GZgAL66pOc) How can I aggregate text with no numeric values? I'd like to aggregate some data that doesn't include any numbers. I have a list of Applications, made up of application components, made up of application elements. Here's my query:
=QUERY('App Elements'!A1:C99,"SELECT A, B GROUP BY A, B ORDER BY A, B")
Pretty simple, but I get the following error.
error: Invalid query: Cannot use GROUP BY when no aggregations are defined in SELECT.
A sample of my data is
A B C
1 App 1 Comp 1 Ele 1
2 App 1 Comp 1 Ele 2
3 App 1 Comp 2 Ele 1
4 App 2 Comp 1 Ele 1
5 App 2 Comp 1 Ele 2
1 App 1 Comp 1
2 App 1 Comp 2
3 App 2 Comp 1
I can add a dummy column to average or sum and then hide the results, but surely there is a more legitimate way of getting this output.