WRAPCOLS in WPS on Windows: Introduction

WRAPCOLS in WPS on Windows is an array function for reorganizing one-dimensional data into multiple columns; 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 a spreadsheet function in WPS Office for Windows that rearranges a single row or single column of data into a multi-column array based on the specified count. When you type the formula, the editing area shows syntax guidance to help you confirm the parameter order and input method.

Core capabilities include:

Enter the WRAPCOLS function and view syntax guidance before completing the formula.
Fill in the required parameters and return the reorganized result in worksheet cells.
Combine WRAPCOLS with cross-sheet references and nested calculations to organize result areas for analysis.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	Local formula calculation does not require a network connection; download, installation, and account services do
Other	You need access to WPS Spreadsheet files and permission to edit formulas in cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Spreadsheet, open a workbook, and type `=WRAPCOLS(` in the formula bar to confirm that formula input and result output are available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, typing `WRAPCOLS(` shows syntax guidance and lets you reorganize one-dimensional data into an array arranged by columns.	Excel provides the WRAPCOLS function with the syntax `WRAPCOLS(vector, wrap_count, [pad_with])` to wrap a vector by columns and optionally pad missing values.	Google Sheets provides the WRAPCOLS function with the syntax `WRAPCOLS(range, wrap_count, [pad_with])` to wrap a row or column into a new array by columns.	Notion provides database formulas, lists, and function syntax for property calculations, but it does not provide a spreadsheet WRAPCOLS function with the same name.	Adobe Acrobat Sign provides calculated fields for dynamic form values, but it does not provide a spreadsheet WRAPCOLS array function.
WPS Advantages	Advantage: You can start directly in a worksheet cell by typing the function, then continue with cross-sheet references and nested calculations in the same spreadsheet workflow.	Compared with WPS: Excel also provides a comparable WRAPCOLS function and documents its error behavior and padding rules in detail.	Compared with WPS: Google Sheets also provides a comparable WRAPCOLS function and documents rounding for `wrap_count` and the behavior of `pad_with`.	Compared with WPS: Notion is oriented toward database property formulas rather than cell-based spreadsheet functions.	Compared with WPS: Adobe focuses on PDF form calculations rather than spreadsheet array reshaping.
Official Source	—	Excel WRAPCOLS function	Google Sheets WRAPCOLS function	Notion formula syntax	Adobe calculated fields

Overall Conclusion
WRAPCOLS is an array reshaping function in spreadsheet workflows, and WPS, Excel, and Google Sheets all provide closely related function support. If your work centers on cell formulas and arranging result ranges, WPS offers a direct worksheet-based path, while Notion and Adobe are better suited to database or PDF form scenarios rather than the same spreadsheet function category.

Use Cases

No.	Scenario	Suitable for	Main challenge	How WRAPCOLS helps
1	Displaying long lists in columns	Administrative and operations staff	A long single-column list is hard to print or review in sections	Use WRAPCOLS to reorganize the list into multiple columns with a fixed count
2	Organizing result ranges	Data analysts	A formula output in one row or one column is hard to format for the next step	Use WRAPCOLS to expand the result into columns in the target area
3	Summarizing cross-sheet results	Finance and project teams	Results from multiple sheet references need a clearer structure	Nest WRAPCOLS with cross-sheet references to output a multi-column array
4	Teaching and demonstrations	Trainers and students	It can be hard to explain how array reshaping works	Use syntax guidance and sample formulas to demonstrate column-based wrapping
5	Building templates	Spreadsheet template maintainers	A fixed layout needs continuous data mapped into columns	Preset WRAPCOLS formulas to fit a fixed column layout

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
WRAPCOLS formula input and calculation	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Advanced PDF editing and more advanced tools	Some functions are limited	Broader access is available
Cloud storage	1 GB	20 GB in some plans

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Daily formula entry and basic spreadsheet organization	Free plan	WRAPCOLS itself can be used directly for routine spreadsheet calculation and result reshaping
Work that also needs more PDF tools, cloud storage, or sharing features	WPS Premium	Suitable for office scenarios that need more advanced tools and larger cloud storage

WPS membership center: Subscribe now