# Google Sheets FLATTEN Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/flatten-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The FLATTEN function converts a range or array into a single column, combining all values into one vertical list. ``` FLATTEN(range1,[range2,...]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the FLATTEN you need in plain EnglishGenerate Formula ## Parameters **`range1`**:\ The first range of cells that you want to flatten into a single column. **`range2`**:\ An optional additional range of cells that you want to include in the flattening process. You can include multiple ranges separated by commas. ## What is the FLATTEN Function? The *FLATTEN* function in Google Sheets is a useful tool that allows you to convert a range or array of values into a single column. This function is particularly helpful when you want to simplify data presentation or when you need to work with data in a linear format. By flattening a range, you can easily manipulate and analyze data without dealing with multiple rows and columns. In simpler terms, FLATTEN takes a multi-dimensional array and transforms it into a one-dimensional array, making it easier to work with in various scenarios. ## A Practical Example Imagine you have a table of sales data for different products, organized in a grid format: ### Sales Data Table: | Product | Q1 Sales | Q2 Sales | Q3 Sales | | - | - | - | - | | Widget A | 100 | 150 | 200 | | Widget B | 120 | 130 | 140 | | Widget C | 90 | 110 | 95 | You want to create a single column that lists all the sales figures for each product across all quarters. ## FLATTEN Formula To achieve this, you would use the FLATTEN function as follows: ``` =FLATTEN(A2:D4) ``` In this formula: - `A2:D4` is the range that contains the sales data, including product names and sales figures. ## Result of the Formula When you apply the FLATTEN formula to the Sales Data Table, the output would look like this: | Sales Figures | | - | | Widget A | | 100 | | 150 | | 200 | | Widget B | | 120 | | 130 | | 140 | | Widget C | | 90 | | 110 | | 95 | As you can see, the FLATTEN function has transformed the multi-dimensional array into a single column, making it easier to analyze the sales figures. ## Why Use FLATTEN? FLATTEN is beneficial because it simplifies the organization of data, allowing for easier analysis and manipulation. It can be particularly useful when you need to prepare data for charts, pivot tables, or other analytical tools that require a linear format. Additionally, it helps in cleaning up data by removing the complexity of multiple rows and columns. ## Key Takeaways: - **FLATTEN**: A Google Sheets function that converts a multi-dimensional array into a single column. - **Simplifies Data**: Makes it easier to analyze and manipulate data in a linear format. - **Common Use Cases**: Ideal for preparing data for charts, pivot tables, and other analytical tools. FLATTEN is an essential function for anyone working with data in Google Sheets, providing a powerful way to enhance data organization and analysis capabilities. Happy spreadsheeting! ## Example use case You have a table with multiple columns for sales data across different regions. By using the FLATTEN formula, you can convert this multi-column data into a single column list, making it easier to analyze total sales figures without losing any information. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Make A Pie Chart In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-pie-chart-in-google-sheets) - [How To Make A Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-table-in-google-sheets) - [How To Merge Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-merge-cells-in-google-sheets) - [How To Multiply In Google Sheets](https://betteranalyst.com/google-sheets/how-to-multiply-in-google-sheets) - [How To Password Protect An Google Sheets File](https://betteranalyst.com/google-sheets/how-to-password-protect-an-google-sheets-file) - [How To Remove Blank Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-blank-rows-in-google-sheets) - [How To Remove Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-duplicates-in-google-sheets) - [How To Separate Names In Google Sheets](https://betteranalyst.com/google-sheets/how-to-separate-names-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.