Pivot Table Issues

Why a PivotTable Does Not Repeat Every Document Number in WPS Spreadsheets

Jason Miller Nov 13, 2026 869 views

Question details

The user needs to understand why a PivotTable in WPS Spreadsheets shows one summarized row per document number instead of repeating each document number according to its order quantity.

Why a PivotTable Does Not Repeat Every Document Number in WPS Spreadsheets

Product: WPS Spreadsheets
Device & OS: not provided
Scenario: The user has source data where a document number has an order quantity such as 7 and expects the PivotTable to display seven identical records, for example 84 pieces represented as seven repeated rows.
Observed behavior: The PivotTable groups and aggregates the source data, so it shows one row per document number with the quantity total rather than repeating each record multiple times.

Before you start

Open the workbook in WPS Spreadsheets and check whether your source data contains one physical row per record or a quantity column such as “Order Quantity” that you want to expand into multiple rows.

Solution 1Recommended

Expand the source data with a repetition column before creating the PivotTable

Use this when you need every quantity unit to appear as its own row in the PivotTable; the PivotTable then repeats the document number for each expanded record.

A PivotTable always aggregates a source list. If your source list has one row with quantity 7, the PivotTable correctly shows 7 as a total. To see seven repeated rows, you must first create seven source rows.

Add a Repeat Count column

In the source data, insert a column named “Repeat Count” and enter how many times each document number should appear.

Create an expanded data sheet

Create a new worksheet and copy the original column headers into it.

Copy each record down by its repeat count

For each source row, copy the row downward until the quantity is represented as individual rows, and repeat this process for all document numbers.

Build the PivotTable from expanded data

Select the expanded range, click Insert > PivotTable, and choose the document number and quantity fields. The document number now appears once per repeated row.

Expand the source data with a repetition column before creating the PivotTable

Expanded rows work: After expanding the source data, the PivotTable can repeat a document number according to the quantity instead of showing one aggregated total.

Solution 2

Use a regular worksheet report when you only need to display repeated rows

Choose this if you do not need PivotTable interactivity and want faster, formula-free control over row layout.

Solution 3

Use Power Query or a query editor to generate rows when the feature is available

Use this method for large datasets when your spreadsheet version includes a query editor or Power Query.

WPS Spreadsheets PivotTable

Create Repeated PivotTable Records in WPS Spreadsheets

Use WPS Spreadsheets to expand your source records with a repetition column, then build a PivotTable that shows document numbers repeated per quantity. You get a free, familiar spreadsheet workflow without needing complex Office add-ins.

1. Download and open WPS Spreadsheets: Download WPS Office from the official site, install it, then open the workbook containing the document numbers and quantities.
2. Add a repetition or quantity column: In your source table, insert a column named “Repeat Count” or use the existing order quantity as the number of rows to create.
3. Expand records in a new sheet: Create a new worksheet, copy the headers, and copy each source row down according to the repeat count.
4. Insert a PivotTable: Select the expanded range and click Insert > PivotTable, then place the PivotTable on a new worksheet.
5. Confirm repeated rows: Drag Document Number to Rows and Quantity to Values. Each document number now appears once for each repeated source record.

Creates a PivotTable that repeats document numbers according to order quantityWorks with .xlsx, .xls, and .csv files for full Microsoft Excel format compatibilityFree and lightweight spreadsheet tool with a familiar ribbon interfaceLets you keep source data and expanded records in the same workbook

microsoft office alternative - wps office

Frequently Asked Questions

Why does my PivotTable show one row instead of seven identical document numbers?

PivotTables are designed to group and aggregate source data. If your source data contains one row per document with an order quantity of 7, the PivotTable will show one total row instead of seven repeated rows.

Can a PivotTable repeat rows automatically based on a quantity column?

Not directly. You must create one source row per repeated record before building the PivotTable, or use a regular worksheet report where you copy the document number the required number of times.

How do I expand 84 pieces into seven repeated rows in WPS Spreadsheets?

Add a Repeat Count column to the source data, create a new worksheet, copy each record down according to the repeat count, and then build the PivotTable from the expanded range.

Does WPS Spreadsheets include Power Query for row expansion?

Power Query availability depends on your WPS Office version and edition. If it is not available, use a helper column and copy rows down, or build a regular worksheet report with SUM formulas.

What should I do if I only need a printable report, not an interactive PivotTable?

Use a regular worksheet range. Copy each document number the required number of times according to the order quantity, then add totals with SUM formulas instead of using a PivotTable.

Excel & Data Problems