WRAPCOLS in WPS Spreadsheet: Arrange a Row into Fixed-Height Columns

=WRAPCOLS(vector,row_count,pad_value)

The source is a one-dimensional row in the demonstrated case. row_count sets the height of each output column. pad_value fills unused positions at the end; this guide explicitly uses "". The examples do not establish all accepted input orientations or arbitrary padding types.

Enter A1:G1 as A, B, C, D, E, F, G, one letter per cell. Reserve A4:C6 and enter =WRAPCOLS(A1:G1,3,"") at A4. The independently expected result is:

The "" notation in this table means an empty-string result that appears blank; it is not visible quotation-mark text. The first column receives A, B, C; the second receives D, E, F; the third starts with G and has two padded positions. Three rows times three columns gives nine slots, of which seven hold original values.

In E4, reserve E4:H5 and use =WRAPCOLS(A1:G1,2,""). Expected E4:H5 is:

Changing the height from three to two changes the number of columns from three to four. For this positive-size case, the column count is the smallest integer large enough to hold all values: seven values require four columns of height two. Eight slots minus seven values leaves one padding position. Nothing is sorted; reading down each result column reconstructs the original sequence.

The official final formula at 37.995 seconds is =WRAPCOLS(A5:Z5,5,""). The 26 letters occupy a 5-by-6 result, ending with Z and four empty-string positions in the last column. The live dialog help describes default padding as #N/A; the narration’s instruction to enter "" must not be rewritten as a default-blank claim. The displayed result was produced with an explicit third argument.

This guide uses that exact padding choice throughout. It does not use the default in a calculated example or promise that padded results behave like physically empty worksheet cells in every other function.

• If letters run across rows when you wanted them down columns, check that you chose WRAPCOLS and that the second argument is the desired height.
• Count both real values and padding slots when reserving the result rectangle.
• Include the explicit third argument to reproduce the blank-looking last column.
• Use a single-row source and positive whole-number height for these controls.
• Two-dimensional inputs, vertical sources, nonpositive/fractional sizes, error inputs, alternative padding and precise error contracts remain outside the verified examples. Installed-version availability still needs checking.

Compare WRAPROWS when values should run across each output row. COLUMNS can help check the width of the horizontal input vector.

The official WPS WRAPCOLS lesson and its linked video show a Chinese-language WPS spreadsheet interface with a WPS AI label. The actual demonstration was reviewed on October 19, 2026. No numeric build, exact edition, operating system, license or release-date label was verified. This is genuine historical product evidence, not an introduction-version claim or proof of support in every current desktop, web or mobile edition.

The video enters a formula at an output cell and shows an array result occupying neighboring cells. Confirm function recognition and the array-entry workflow in your intended installation before using these examples in a shared workbook. This guide does not import Excel’s complete spill, default-argument or error contract.

• Official WPS WRAPCOLS lesson
• Official lesson video

The cited timestamps refer to that vendor video. Vendor frames were inspected as source evidence; no vendor frame is embedded here or represented as a screenshot from our own testing. Original example outputs were independently reasoned and checked as array transformations, not executed in an installed WPS build. Unresolved behavior is excluded from the asserted recipe.