ABCDEFGHIJKLMNOPQRSTUV
1
Go to File > Make a copy to get started
2
AID FOR LEARNING QUERY (V1)
3
Enter Data Range or NameSAMPLEDATAUse 'SAMPLEDATA' or your own source"
4
Optional HeadersThe number of rows for your header data
5
6
1Select one of the examples in blue from the dropdown and ensure the purple box is empty. The query will compute and the complete formula shown in the green preview.PREVIEW OF
FORMULA
=query(PIVOTANDGROUPSAMPLE, "SELECT B, SUM(C) GROUP BY B PIVOT A")
7
8
SELECT AN EXAMPLEPIVOTThe datasource used has been changed to 'PIVOTANDGROUPSAMPLE' as shown in preview of formula
9
10
2You can try your own statements in the purple box, typing only the statement highlighted below (no quotes needed)
11
TYPE YOUR OWN STATEMENT
12
13
=QUERY(DATARANGE,"QUERY STATEMENT", [OPTIONAL HEADERS]
14
15
16
3You can also query your own data with this tool. Just add your data to a new tab and update the Data Range or Named Range in the yellow area accordingly (Cell N3)BrandDEEN-GBEN-USESFR
17
ALPINESTARS125877623061875758
18
BELSTAFF2845176224124511453
19
BULL-IT951414138624681665
20
KTM8972575180260765
21
OXFORD109264916702143279
22
CLAUSESLOGICALARITHMETICSCALAR
23
24
SELECTAND+LOWER
25
WHEREOR-UPPER
26
GROUP BYNOT*
27
PIVOT/MORE SCALAR
28
ORDER BY
29
LIMIT
30
OFFSETAGGREGATIONCOMPARISON
STRING COMPARISON
31
LABEL
32
FORMATSUM>CONTAINS
33
OPTIONSAVG<STARTS WITH
34
MIN=ENDS WITH
35
MAX<=MATCHES
36
COUNT>=LIKE
37
*Format, options and like
will be added ASAP.
!= OR <>
38
39
IS NULL
40
IS NOT NULL
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100