REPTARRAY in WPS Spreadsheet: Repeat a Whole Label Block in WPS

=REPTARRAY(array,row_count,column_count)

The video names an input array and row/column repetition counts. In its demonstrated horizontal case, row_count=1 and column_count=2 repeat a three-cell row into six result cells. This guide treats the counts as repetition factors for that bounded pattern, rather than dimensions of the finished rectangle.

Do not confuse REPTARRAY with a function that repeats characters inside one text cell. Its demonstrated output is a multi-cell array.

Enter A1=Plan, B1=Actual, C1=Gap. Leave E1:J1 clear and enter =REPTARRAY(A1:C1,1,2) in E1. Independently expected values are:

The source block has three cells and is repeated twice, producing 3 × 2 = 6 cells. The order is block-wise: Plan, Actual, Gap followed by the same block. It is not Plan, Plan, Actual, Actual, Gap, Gap.

Enter A5=Opened tickets, B5=Closed tickets, C5=Backlog. At E5 enter =REPTARRAY(A5:C5,1,2) with E5:J5 clear. Expected output is Opened tickets, Closed tickets, Backlog, Opened tickets, Closed tickets, Backlog in six cells. Each source cell remains one value, even though two labels contain spaces.

This uses the same demonstrated repetition counts while showing a practical reporting layout. The formula repeats field labels only; it does not create months, calculate backlog, or assign new formulas beneath the repeated headings. Put any period labels in a separate row and validate calculations separately.

The official video also shows =REPTARRAY(SEQUENCE(3),2,) at 91.506 seconds, with a vertical result 1, 2, 3, 1, 2, 3. It depends on SEQUENCE being available and leaves the third argument empty. The expected six positions follow from repeating the three-number block twice.

That exact observation is useful when reviewing an existing workbook, but it does not prove every REPTARRAY default, every SEQUENCE omission rule, or that omitting column_count is interchangeable with all explicit values on every client. The original small examples above avoid this additional dependency and supply both repeat counts.

At 53.479 seconds the formula bar shows =REPTARRAY(B25:D25,1,2). The three source headings mean unit price, quantity and total. The result repeats the three headings twice in six cells. It is shown within a formatted reporting sheet, but the formula result alone does not establish that source formatting or merged headings are replicated.

• Multiply source width by horizontal repetitions when reserving output space: three cells repeated twice need six cells.
• Compare the result block by block, rather than expecting each individual cell twice in succession.
• If the generated-sequence example is unavailable, check both function names in the installed WPS build.
• Two-dimensional tiling, other repetition counts, zero/negative/fractional counts, default arguments beyond the exact observed vertical case, maximum sizes and exact error contracts remain unverified. No claim of availability in Excel or all WPS editions is made.

See REPT for repeating text within a cell, and SEQUENCE for the number-grid function used in the observed vertical example. Each guide has its own historical availability limits.

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