Flattens all the values from one or more ranges into a single column. Learn more
The FLATTEN function in Google Sheets takes a range of cells that contain multiple rows or columns of data and returns a one-dimensional array with all the data flattened into a single column.
For example, if you apply the FLATTEN function to this range (i.e., =FLATTEN(A1:B3)), the function will return a one-dimensional array with all the data flattened into a single column.