How can I convert a table to a list in Google Sheets?

By /

To convert a table to a list in Google Sheets, follow these steps:

1. Select the table you want to convert.
2. Right-click on the table and select “Copy” or press “Ctrl+C” on your keyboard.
3. Right-click on a cell where you want to paste the list and select “Paste special” or press “Ctrl+Shift+V”.
4. In the pop-up window, select “Paste values only” and click “OK”.
5. Your table will now be converted into a list format.

Alternatively, you can also use the “Transpose” function in Google Sheets to convert a table into a list. Simply select the table, then go to “Edit” and select “Transpose” from the drop-down menu.

Converting a table to a list in Google Sheets can be useful for organizing data and making it easier to read and analyze. It is a simple and efficient way to transform your data into a more user-friendly format.

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 .

Additional Resources

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

x

Related terms:

  1. How can I convert a pivot table to a table on Google Sheets?
  2. How can a table be converted to a list in Google Sheets?
  3. How to Convert a Pivot Table to a Table in Excel
  4. How to Create Pivot Table from Multiple Sheets in Google Sheets?
  5. Google Sheets: Highlight Cell if Value Exists in List
  6. Google Sheets: Create a List Based on Criteria
  7. How to Check if Cell Contains Text from List in Google Sheets
  8. How to Filter by List of Values in Google Sheets?
  9. How to Select a Random Value From a List in Google Sheets
  10. Can Google Sheets search for a value in a list and return a Yes or No answer?