# Google Sheets WRAPCOLS Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/wrapcols-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 WRAPCOLS function arranges a single-column range into multiple columns, wrapping values into new rows as needed. ``` WRAPCOLS(range, wrap_count, [pad_with]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the WRAPCOLS you need in plain EnglishGenerate Formula ## Parameters **`range`**:\ The range of cells that you want to wrap into columns. **`wrap_count`**:\ The number of columns to wrap the specified `range` into. **`pad_with`**:\ (Optional) The value to use for padding the resulting array if the total number of cells in the `range` is not evenly divisible by `wrap_count`. ## What is WRAPCOLS? The *WRAPCOLS* function in Google Sheets is a useful tool that allows you to rearrange a single column of data into multiple columns. This function is particularly helpful when you want to present data in a more organized and visually appealing way, making it easier to read and analyze. By specifying the number of columns you want to create, WRAPCOLS automatically wraps the data into the desired format. In simpler terms, WRAPCOLS helps you transform a long list of items into a grid layout, which can be especially beneficial for reports, dashboards, or any situation where you want to display data more effectively. ## A Practical Example Imagine you have a list of fruits that you want to display in a grid format: ### Fruits List: | Fruits | | - | | Apple | | Banana | | Cherry | | Date | | Elderberry | | Fig | | Grape | | Honeydew | You want to display these fruits in 3 columns instead of a single column. ## WRAPCOLS Formula To achieve this, you would use the WRAPCOLS function as follows: ``` =WRAPCOLS(A2:A9, 3) ``` In this formula: - `A2:A9` is the range containing the list of fruits. - `3` is the number of columns you want to create. ## Result of the Formula When you apply the WRAPCOLS formula to the Fruits List, the output would look like this: | Column 1 | Column 2 | Column 3 | | - | - | - | | Apple | Date | Grape | | Banana | Elderberry | Honeydew | | Cherry | | | | Fig | | | As you can see, the fruits are now organized into three columns, making it easier to read. ## Why Use WRAPCOLS? WRAPCOLS is beneficial because it simplifies the process of organizing data in Google Sheets. It allows you to present information in a structured format without manually rearranging the data. This can save time and enhance the visual appeal of your spreadsheets, making them more user-friendly. ## Key Takeaways: - **WRAPCOLS**: A Google Sheets function that rearranges a single column of data into multiple columns. - **Customizable**: You can specify the number of columns to create, allowing for flexible data presentation. - **Efficiency**: Saves time by automating the process of organizing data, reducing the need for manual adjustments. - **Common Use Cases**: Ideal for displaying lists, creating dashboards, and enhancing the readability of data in spreadsheets. WRAPCOLS is an essential function for anyone looking to improve the organization and presentation of data in Google Sheets, providing a straightforward way to enhance your spreadsheets. Happy spreadsheeting! ## Example use case You have a list of product names in a single column. By using WRAPCOLS, you can rearrange the data into multiple columns, making it easier to view and compare products side by side, enhancing organization and readability for inventory management. ## 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 Enable Macros In Google Sheets](https://betteranalyst.com/google-sheets/how-to-enable-macros-in-google-sheets) - [How To Filter In Google Sheets](https://betteranalyst.com/google-sheets/how-to-filter-in-google-sheets) - [How To Find Circular References In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-circular-references-in-google-sheets) - [How To Find Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-duplicates-in-google-sheets) - [How To Freeze A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-a-row-in-google-sheets) - [How To Freeze Panes In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-panes-in-google-sheets) - [How To Highlight Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-highlight-duplicates-in-google-sheets) - [How To Insert Checkbox In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-checkbox-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.