WRAPCOLS in WPS Sheets is a built-in array function for reorganizing results by column; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
WRAPCOLS is an array function in WPS Sheets that rearranges one-dimensional data into multiple columns based on a specified column count. It is useful for organizing lists, reshaping dynamic array results, and improving spreadsheet layout in WPS Office.
Core tasks include:
- Insert WRAPCOLS from the Insert Function dialog box.
- Type the
=WRAPCOLS(...)formula directly in a cell or in the formula bar. - Review syntax, arguments, and help information before applying the formula.
This function is useful for roster formatting, dynamic array cleanup, structured output design, and spreadsheet learning.
System Requirements
| Item | Requirement |
|---|---|
| OS | A Windows device that can run WPS Office |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No required internet connection for local formula entry; internet access is needed for online help or downloads |
| Other | You need access to WPS Sheets and permission to edit the worksheet |
Download & Installation
Before using WRAPCOLS, install the Windows version of WPS Office with spreadsheet editing support.
| Item | Notes |
|---|---|
| Official Download | WPS Office Free Download |
| Post-install Check | Open WPS Office, open a spreadsheet, and confirm that the Formula tab and formula bar are available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | WPS Sheets provides the WRAPCOLS function for wrapping a row or column of values by columns through either direct formula entry or the Insert Function workflow. | Excel provides the WRAPCOLS function to wrap a row or column of values by columns into a new array and supports the optional pad_with argument. | Google Sheets provides the WRAPCOLS function to wrap a row or column of cells by columns into a new array and supports an optional fill value. | Notion formulas can perform calculations with database properties, built-ins, and functions, but they are designed for database properties rather than spreadsheet cell formulas. | Acrobat can configure calculation fields in PDF forms, which supports form-based calculations rather than spreadsheet array reshaping. |
| WPS Advantages | Advantage: You can use WRAPCOLS directly in worksheet cells for column-based array reshaping. Advantage: WPS also supports both dialog-based insertion and manual formula entry in a desktop sheets workflow. | Compared with WPS: Microsoft documents the same function with syntax, remarks, and error behavior for Excel. Both products fit spreadsheet array-wrapping tasks. | Compared with WPS: Google documents the same function with syntax and examples in Google Sheets. WPS offers a Windows desktop spreadsheet workflow for local editing. | Compared with WPS: Notion is stronger for database-property formulas, but it is less direct for cell-level array layout tasks. | Compared with WPS: Adobe focuses on PDF form calculations, so worksheet-style array wrapping is outside its main use case. |
| Official Source | — | WRAPCOLS function | WRAPCOLS function | Intro to formulas | Configure form field calculations in Acrobat |
Overall Conclusion
If your main goal is spreadsheet array reshaping by column, WPS provides a direct workflow in WPS Sheets. Microsoft Excel and Google Sheets also document the same function, while Notion and Adobe focus on database formulas and PDF form calculations instead.
Use Cases
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | Roster layout by columns | Admin staff, teachers, operations staff | A single long list is hard to print or review | Use WRAPCOLS to reshape the list into a fixed number of columns |
| 2 | Dynamic array cleanup | Data handlers | One-dimensional formula output is hard to read | Use WRAPCOLS to split the result across multiple columns |
| 3 | Template building | Spreadsheet template maintainers | Output areas need a cleaner structure | Combine WRAPCOLS with other formulas for structured layouts |
| 4 | Formula learning | New users | Function syntax and arguments are unfamiliar | Use the Insert Function dialog and help entry to review the formula |
| 5 | Faster formula entry | Everyday office users | Menu navigation takes extra time | Type =WRAPCOLS(...) directly in a cell |
Membership & Benefits
Free vs WPS Premium
| Feature | Free User | WPS Member |
|---|---|---|
| Basic WRAPCOLS formula entry | ✅ | ✅ |
| Basic PDF features | ✅ | ✅, with more extended capabilities |
| Cloud storage | 1 GB | 20 GB |
| Template downloads | Limited | More template benefits |
| AI tools | Limited access for some features | More AI-related capabilities |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| Learning WRAPCOLS and handling basic spreadsheet work | Free version | It already supports formula entry, editing, and basic calculations |
| Needing more cloud storage, templates, or broader office features | WPS membership | It is a better fit for long-term, multi-device, or broader productivity needs |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page