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:

=FLATTEN(B2:E4)

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:

=FLATTEN(B2:E4)

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.

For example:

- 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.

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

Google Sheets: How to Create a List Based on Criteria

Google Sheets: Search for Value in List and Return Yes or No

Google Sheets: Highlight Cell if Value Exists in List