How to Convert a Table to List in Google Sheets


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:

Google Sheets convert table to list

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

Leave a Reply

Your email address will not be published. Required fields are marked *