How to Create Unique List Across Multiple Columns in Google Sheets

To create a unique list across multiple columns in Google Sheets, you can use the 'UNIQUE' function combined with the 'FLATTEN' and 'SPLIT' functions. Follow these steps to create a unique list:

1. First, make sure your data is organized in columns.
2. Create a new sheet or a new section in your existing sheet to place the unique list.
3. Use the 'FLATTEN' function to merge all columns into one column. This function will stack all the data from your columns into a single column.
4. Use the 'SPLIT' function to separate the values based on the delimiter (e.g., comma or space) if necessary.
5. Finally, use the 'UNIQUE' function to filter the unique values from the flattened and split data.

Example

Let's assume you have the following data in columns A, B, and C:

  A      B      C
1 Red    Blue   Yellow
2 Green  Red    Pink
3 Blue   Green  Orange

To create a unique list across these columns, follow these steps:

1. Go to a new sheet or a new section in your existing sheet.
2. In cell A1, enter the following formula:

=UNIQUE(FLATTEN(A1:C3))

This formula will flatten the data in the range A1:C3 and then filter out the unique values.

3. Press Enter, and the unique list will be displayed in column A:

  A
1 Red
2 Green
3 Blue
4 Yellow
5 Pink
6 Orange

The resulting list contains all the unique values across columns A, B, and C.