TOROW in WPS Spreadsheet: Flatten a Grid by Columns with Explicit Blank Handling

=TOROW(array,ignore,scan_by_column)

• array is the input rectangle.
• ignore selects which inputs to omit. The video menu exposes modes 0, 1, 2 and 3; its worked formula uses 3.
• scan_by_column=TRUE reads each column from top to bottom before proceeding to the next column.

The observed source contains ordinary text plus two empty cells, but no error-valued cells. The evidence therefore corroborates omission of those blanks with mode 3, not a fully tested error-filtering contract. Formulas returning empty strings and cells containing spaces are not the same fixture as truly empty cells.

Enter A1=P1, B1=P2, C1=P3, A2=Q1, B2=Q2, and leave C2 genuinely empty:

The word (empty) is explanatory; do not type it into C2. In E1, with E1:I1 clear, use =TOROW(A1:C2,3,TRUE). Independently expected E1:I1 is P1, Q1, P2, Q2, P3.

Trace A1 → A2 → B1 → B2 → C1 → C2. The last position is blank and omitted, leaving five values. This is a traversal check, not a new application execution.

Enter A5:C7 as follows, again leaving the marked cells genuinely empty:

In E5, reserve seven cells through K5 and enter =TOROW(A5:C7,3,TRUE). The expected row is R1, R2, R3, S1, S2, T1, T2. The first column contributes three values, the next two columns two apiece: 3 + 2 + 2 = 7. This preserves the demonstrated text-and-empty-cell contract while making column boundaries easier to audit.

At 88.512 seconds, the official formula is =TOROW(A1:D7,3,TRUE). The input is A–Z laid out across four columns, with two trailing empty cells. Its output begins A, E, I, M, Q, U, Y, then B, F and so on, ending D, H, L, P, T, X. This establishes column scanning rather than merely confirming a one-row shape. The earlier row-major illustration produces A–Z; the examples here deliberately use explicit TRUE to avoid relying on an omitted scan argument.

• If you expected P1, P2, P3 first, you were expecting row-first traversal; TRUE requests column-first traversal in this guide.
• Count nonempty input cells before reserving output width.
• Clear the test input’s designated empty cells; do not substitute spaces, zeros or ="".
• Error-valued inputs, mode 0/1/2 results, text-empty-string handling, default selectors, size limits and exact spill errors are not verified by these fixtures.

After understanding flattening order, compare WRAPROWS for arranging a horizontal vector into fixed-width rows. COLUMNS explains how to measure a referenced range’s width.

The official WPS TOROW 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 TOROW 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.