FLATTEN Function

The FLATTEN function is great when you want to combine multiple lists into one big list. Simply write =FLATTEN() and select the range of all lists that you want to combine.
You can also select different ranges by adding a comma between them like so.
Then you will end up with one big list containing the individuals of multiple smaller lists!