=WRAPROWS(array, wrap_count, [pad_with])One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single WRAPROWS formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
array:
The range or array of values that you want to wrap into rows.
wrap_count:
The number of items to include in each row of the wrapped output.
pad_with:
(Optional) The value to use for padding if the total number of items in the array is not evenly divisible by wrap_count. If omitted, Excel uses #N/A as the padding value.
The WRAPROWS function in Excel is a useful tool that allows you to rearrange a single-column range of values into a multi-row format. This function takes a specified number of columns and wraps the data into rows, making it easier to visualize and analyze data in a structured manner.
In simpler terms, the WRAPROWS function helps you convert a long list of values into a more manageable format, enhancing readability and organization.
Imagine you have a list of product names in a single column in an Excel spreadsheet:
| Products |
|---|
| Apples |
| Bananas |
| Cherries |
| Dates |
| Elderberries |
| Figs |
| Grapes |
| Honeydew |
You want to display these products in a 3-column format for better visibility.
To rearrange the product list into a 3-column format, you would use the WRAPROWS formula as follows:
=WRAPROWS(A2:A9, 3)When you apply the formula, it rearranges the product names into three columns. The output would be:
| Column 1 | Column 2 | Column 3 |
|---|---|---|
| Apples | Cherries | Grapes |
| Bananas | Dates | Honeydew |
| Elderberries | Figs |
Here, the products are now organized into a more readable format across three columns.
The WRAPROWS function is particularly useful when you need to present data in a more structured format, making it easier to read and analyze. It allows you to quickly convert long lists into a grid layout, enhancing the visual appeal of your data.
Understanding how to use the WRAPROWS function can significantly improve the way you present and analyze data in Excel, making your datasets more accessible and easier to interpret.
Happy organizing!
You have a list of product names in a single column and you want to display them in a more organized manner across multiple rows and columns for a presentation. By using the WRAPROWS function, you can transform the single-column list into a grid format, making it easier to visualize and compare products at a glance. This enhances the clarity of your presentation and helps in effectively communicating product offerings without the need for manual formatting.
Beyond the WRAPROWS function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.