You can use the FLATTEN function in Google Sheets to convert a table of data into a vertical list.
For example, you can use the following formula to convert a table with three rows into a vertical list:
The following example shows how to use this formula in practice.
Example: Convert a Table to List in Google Sheets
Suppose we have the following dataset in Google Sheets that displays the total sales made by some company during each quarter of three consecutive years:
Suppose we would like to convert this table into a vertical list.
We can type the following formula into cell A6 to do so:
The following screenshot shows how to use this formula in practice:
We can see that the formula was able to successfully convert the table of values into a single list that shows the sales values for each quarter and year.
- The first value in the list shows the sales for Q1 2021.
- The second value in the list shows the sales for Q2 2021.
- The third value in the list shows the sales for Q3 2021.
- The fourth value in the list shows the sales for Q4 2021.
And so on.
Note: You can find the complete documentation for the FLATTEN function in Google Sheets here.
The following tutorials explain how to perform other common operations in Google Sheets: