Append Multiple Excel Sheets into One Sheet Without Power Query in WPS Office
Question details
The user needs to combine rows from two Excel tables into a single dynamic output sheet using a formula instead of Power Query.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- The user has multiple Excel tables and wants a consolidated sheet that updates when source data changes.
- Observed behavior
- The desired output is a dynamic formula-driven stack rather than a Power Query connection.
Confirm the exact table names in the Table Tools tab or Name Manager, and choose a destination sheet with enough blank cells below and to the right for the stacked spill range.
Use the VSTACK Formula to Append Excel Tables Dynamically
Best for current WPS Office and Excel 365-compatible workbooks when you want a live formula-driven stack without Power Query.
VSTACK is a dynamic array function that stacks arrays or ranges vertically. Referencing a table such as Table1[#All] includes the table header and all data rows, while referencing Table2 without [#All] includes only its data rows.
In WPS Office Spreadsheet, open the workbook that contains the two Excel tables, then click the sheet where the combined output should appear.
Select the first output cell and type =VSTACK(Table1[#All],Table2). This uses the Table1 header and appends the data rows from both tables.
Press Enter to apply the formula. WPS Spreadsheet fills the combined rows automatically; make sure no other data is blocking the area below the formula.
Edit or add a row in either source table and confirm that the destination stack updates automatically.
Use a Range-Based VSTACK Formula for Non-Table Data
Use this when your source data is stored in ordinary worksheet ranges instead of formal Excel Tables.
Append Excel Sheets in WPS Office with the VSTACK Formula
WPS Office lets you stack Excel tables into one dynamic sheet with the VSTACK function—no Power Query, macros, or manual copy-paste required.
- 1. Download and install WPS Office: Go to wps.com and download WPS Office, then install it on your Windows or Mac computer.
- 2. Open the Excel workbook: Launch WPS Office Spreadsheet and open the workbook containing the tables you want to append.
- 3. Enter the VSTACK formula: Click the destination sheet, select a blank cell, and type =VSTACK(Table1[#All],Table2).
- 4. Confirm the dynamic spill range: Press Enter and make sure the area below and to the right is clear so the combined rows display correctly.
- 5. Save in Excel-compatible format: Save the file as .xlsx to maintain compatibility with Microsoft Excel and WPS Office.
Frequently Asked Questions
Does WPS Office support the VSTACK function?
Yes. Current versions of WPS Office Spreadsheet support dynamic array functions including VSTACK. If the function is not available, update WPS Office to the latest version.
Why does my VSTACK formula return a #SPILL! error?
The spill range is blocked by existing data. Clear the cells below and to the right of the formula, or move the formula to a blank area with enough space for the combined rows.
Can I append more than two tables with VSTACK?
Yes. Use =VSTACK(Table1[#All],Table2,Table3,Table4) and separate each table or range with commas.
Does the combined sheet update automatically when source tables change?
Yes. VSTACK creates a dynamic array. When you add, remove, or edit rows in the source tables, the stacked output updates automatically after calculation.
How do I avoid duplicating the second table header?
Reference the first table with [#All] to include one header row, and reference subsequent tables without [#All]. For example, =VSTACK(Table1[#All],Table2) appends only Table2 data rows.
