testingPublic

	A	B	C	D	F	G	H	I	J	M	N	O	P	Q	S	T	U	V	W	X	Y	Z	AA	AB
1	Profile ID	Profile Name	Profile Location	Profile Created	Profile ID	Profile Name	Profile Location	Profile Created	YYYY-MMM	Profile ID	Profile Name	Profile Location	Profile Created	YYYY-MM	Yogi
2	1	AA	Los Angeles	8/4/2016 19:18:14	1	AA	Los Angeles	8/4/2016 19:18:14	2016-08	1	AA	Los Angeles	8/4/2016 19:18:14	2016-08	formula in cell F1 for cells F:F						Profile ID	Profile Name	Profile Location	Profile Created
3	2	BB	Los Angeles	1/3/2017 22:59:36	2	BB	Los Angeles	1/3/2017 22:59:36	2017-01	2	BB	Los Angeles	1/3/2017 22:59:36	2017-01	=ArrayFormula(if(A:A="",,{query(A:D, "select A,B,C"),{"YYYY- MMM"; year(D2:D)&"-"&text(month(D2:D),"00")}}))						1	AA	Los Angeles	08/04/2016
4	3	CC	Los Angeles	3/21/2017 18:59:09	3	CC	Los Angeles	3/21/2017 18:59:09	2017-03	3	CC	Los Angeles	3/21/2017 18:59:09	2017-03							2	BB	Los Angeles	01/03/2017
5	4	DD	Los Angeles	3/31/2017 2:44:54	4	DD	Los Angeles	3/31/2017 2:44:54	2017-03	4	DD	Los Angeles	3/31/2017 2:44:54	2017-03	or						3	CC	Los Angeles	03/21/2017
6	5	EE	Paso Robles	4/25/2017 19:44:03	5	EE	Paso Robles	4/25/2017 19:44:03	2017-04	5	EE	Paso Robles	4/25/2017 19:44:03	2017-04	=if(A:A="",,{query(A:D, "select A,B,C"),query(D:D,"select D label D 'YYYY-MM' format(D) 'YYYY-MM' ")})						4	DD	Los Angeles	03/31/2017
7	6	FF	Boca Raton	4/29/2017 20:50:53	6	FF	Boca Raton	4/29/2017 20:50:53	2017-04	6	FF	Boca Raton	4/29/2017 20:50:53	2017-04							5	EE	Paso Robles	04/25/2017
8	7	GG	Los Angeles	5/2/2017 23:05:26	7	GG	Los Angeles	5/2/2017 23:05:26	2017-05	7	GG	Los Angeles	5/2/2017 23:05:26	2017-05							6	FF	Boca Raton	04/29/2017
9	8	HH	Victoria	5/9/2017 16:06:31	8	HH	Victoria	5/9/2017 16:06:31	2017-05	8	HH	Victoria	5/9/2017 16:06:31	2017-05							7	GG	Los Angeles	05/02/2017
10	9	II	Virginia	5/12/2017 17:33:06	9	II	Virginia	5/12/2017 17:33:06	2017-05	9	II	Virginia	5/12/2017 17:33:06	2017-05							8	HH	Victoria	05/09/2017
11	10	JJ	Philadelphia	5/12/2017 18:51:41	10	JJ	Philadelphia	5/12/2017 18:51:41	2017-05	10	JJ	Philadelphia	5/12/2017 18:51:41	2017-05							9	II	Virginia	05/12/2017
12	11	KK	Los Angeles	5/16/2017 19:12:25	11	KK	Los Angeles	5/16/2017 19:12:25	2017-05	11	KK	Los Angeles	5/16/2017 19:12:25	2017-05							10	JJ	Philadelphia	05/12/2017
13																					11	KK	Los Angeles	05/16/2017
14
15
16																2016-08	2017-01	2017-03	2017-04	2017-05
17															0	1	1	2	2	5
18
19
20
21
22
23															Profile ID	Profile Name	Profile Location	Profile Created	ProfileCreatedDate	ProfileCreatedYYYYMM
24															1	AA	Los Angeles	42586.80433	08/04/2016	2016-08
25															2	BB	Los Angeles	42738.95806	01/03/2017	2017-01
26															3	CC	Los Angeles	42815.79108	03/21/2017	2017-03
27															4	DD	Los Angeles	42825.11451	03/31/2017	2017-03
28															5	EE	Paso Robles	42850.82226	04/25/2017	2017-04
29															6	FF	Boca Raton	42854.86867	04/29/2017	2017-04
30															7	GG	Los Angeles	42857.96211	05/02/2017	2017-05
31															8	HH	Victoria	42864.67119	05/09/2017	2017-05
32															9	II	Virginia	42867.73132	05/12/2017	2017-05
33															10	JJ	Philadelphia	42867.78589	05/12/2017	2017-05
34															11	KK	Los Angeles	42871.80029	05/16/2017	2017-05
35
36
37
38
39
40
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