FLATTEN()

	A	B	C	E	F	H	K
1	Data	Data	Data
2	A	F	K	A	<-- Flatten()	Hi Manvi, or whomever.
3	B	G	L	F		This is Matt, the Google Product Expert Volunteer who flagged this issue to Manvi
4	C	H	M	K		let me know if you have any questions
5	D	I	N	B		3/19/20
6	E	J	O	G
7				L
8				C
9				H		My Canned Response Caveat for Forum Posts Using the function:	Here is the post where it was discovered 3/16/20
10				M		It should be mentioned that FLATTEN() is an undocumented function discovered recently by a user (March 2020). https://support.google.com/docs/thread/33715001?hl=en It's believed it is intended to remain "hidden" in the back end of the sheets programming, but there is no guarantee that the formula will continue to work indefinitely. Here is the demo sheet I made when it was discovered https://docs.google.com/spreadsheets/d/196NDPUZ-p2sPiiiYlYsJeHD6F_eJq7CWO_hP7rFqGpc/edit?usp=sharing	https://support.google.com/docs/thread/33715001
11				D
12				I
13				N
14				E
15				J
16				O
17
18
19
20
21
22
23
24						Update 1/2021: Google has documented FLATTEN()
25						However it still won't "autopopulate" the way other functions do and their sample demo of how it works does not mention the most useful aspect of the function.
26						https://support.google.com/docs/answer/10307761?hl=en
27
28						Update 2/2021: Google has now fixed the Auto-fill and flatten behaves like any other function!
29						it only took a year :P
30
31
32
33
34
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