Function Problems

How to Convert One Excel Row into Multiple Columns with WRAPROWS in WPS Spreadsheets

Algirdas Jasaitis Nov 13, 2026 869 views

Question details

The user needs to reorganize data pasted into a single row into multiple columns using the WRAPROWS function in WPS Spreadsheets.

How to Convert One Excel Row into Multiple Columns with WRAPROWS in WPS Spreadsheets

Product: WPS Spreadsheets
Device & OS: not provided
Scenario: Data has been pasted into one row and needs to be reshaped into a multi-column layout without manually moving cells.
Observed behavior: The source data remains in a single row, and the user requires a formula to dynamically split it into multiple columns.

Before you start

Confirm that your WPS Office version supports dynamic array functions and identify the exact source range and the number of values you want in each row before entering WRAPROWS.

Solution 1Recommended

Use the WRAPROWS Function to Split a Row into Multiple Columns

Best for dynamic, reusable reshaping when you want WPS Spreadsheets to automatically spill the wrapped values.

WRAPROWS returns a spilled array, so the result updates automatically if the source range changes. Make sure the spill area is empty to avoid #SPILL! errors.

Open WPS Spreadsheets and select an output cell

Click the desired empty cell where the wrapped array should begin, such as B3.

Enter the WRAPROWS formula

Type =WRAPROWS(A1:L1,3) and press Enter. Replace A1:L1 with your source row and 3 with the number of values per row.

Use the WRAPROWS Function to Split a Row into Multiple Columns

Dynamic result: The formula spills the row into multiple columns and rows automatically without manual copy-paste.

Reshape a Single Row into Multiple Columns in WPS Spreadsheets

Use the WRAPROWS function in WPS Spreadsheets to convert a one-row range into a clean multi-column layout, just like in Excel. The formula is simple, dynamic, and fully compatible with your existing workbooks.

1. Open WPS Spreadsheets: Launch WPS Office and open the workbook that contains the single-row data.
2. Select a blank output cell: Click an empty cell with enough empty space below and to the right for the spilled result.
3. Enter the WRAPROWS formula: Type =WRAPROWS(range, values_per_row) and press Enter; for example, =WRAPROWS(A1:L1,3).
4. Adjust the column count: Change the second argument to control how many values appear in each wrapped row.
5. Confirm the spilled array: Check that the formula fills the adjacent cells automatically and updates when the source range changes.

Free access to dynamic array functions such as WRAPROWSLightweight and familiar spreadsheet interfaceFull compatibility with Microsoft Excel .xlsx workbooks and formulasAutomatic spill results that update when source data changesNo manual copy-paste or complex VBA needed

microsoft office alternative - wps office

Frequently Asked Questions

What does =WRAPROWS(A1:L1,3) actually do?

It takes the 12 values in A1:L1 and reshapes them into a spilled array with 3 values per row, producing 4 rows by 3 columns.

Does WRAPROWS work in all WPS Office versions?

WRAPROWS requires a version of WPS Spreadsheets that supports dynamic arrays. If the function is not recognized, update WPS Office to the latest version.

Can I wrap rows by a number of columns instead of rows?

WRAPROWS wraps a row or vector into columns based on the wrap_count argument. For a horizontal source, the result uses that count as the number of columns per row.

Why does WRAPROWS return #SPILL!?

The spill area is not empty. Clear enough cells below and to the right of the formula cell before entering the formula.

Is the WRAPROWS result dynamic?

Yes. If you change the source range values or wrap count, WPS Spreadsheets recalculates and spills the new layout automatically.

Excel & Data Problems