Provide the Right Data for a Power Query Transpose to a Specific Column in WPS Office
Question details
The user needs to know what information is required to build a Power Query transformation that transposes data into a specific column and produces the expected output.

- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- A user is preparing a Power Query transformation in WPS Office to transpose existing data into a specific column and needs guidance on the required input information.
- Observed behavior
- The correct Power Query steps cannot be determined without the original data layout, the expected transposed result, and an explanation of which values should become rows or columns.
Open the workbook in WPS Office and identify the source table range, column headers, and the exact target column for the transposed values. Replace any confidential data with neutral placeholders before creating a sample workbook.
Document the Original Layout and Expected Transposed Result
Use this to provide enough information for a Power Query transpose transformation to be designed or troubleshot.
Power Query cannot infer how to place values into a specific column unless the starting table and desired end state are shown clearly.
Launch WPS Office, open the workbook that contains the source data, and go to the worksheet where the original table is stored.
Select the data range that should be transposed, and note the column names or cell references that identify each value.
Add a new sheet, label it Expected Output, and manually type the exact rows and columns you want after the Power Query transform.
Replace real names, numbers, or confidential values with sample placeholders such as Name1, Region A, or 12345 while keeping the same table structure.
Save the workbook in .xlsx format and include a short note stating which values should become rows, which should become columns, and which target column should receive the transposed data.

Build a Power Query Transpose to a Specific Column in WPS Office
WPS Office Spreadsheet includes Power Query, so you can import a source table, apply transpose or unpivot transformations, and load the result into the intended worksheet column once the expected layout is defined.
- 1. Open Power Query in WPS Office: In WPS Office Spreadsheet, open the Data tab and choose Power Query to import the source table.
- 2. Import the source table: Select the original data range, use From Table/Range, and review the preview to confirm all columns and rows are loaded.
- 3. Apply the transpose or unpivot transformation: Select the columns that need to become rows, use Transform > Transpose or Unpivot Columns, and adjust the query so the values move into the intended target column.
- 4. Load the result to the target worksheet: Choose Close & Load To, select a worksheet and cell, and place the transformed output in the column where the final data should appear.

Frequently Asked Questions
What must I include in a sample workbook for a Power Query transpose request?
Include the original data range, column names, a manually created expected output sheet, and a note explaining which values should become rows or columns. Save it as .xlsx so the structure stays intact.
Why does the starting layout matter when transposing into a specific column?
Power Query transformations are based on the existing rows, columns, and values. Without knowing the starting layout, the merge, unpivot, or transpose steps may place data in the wrong column.
Can I send anonymized data instead of the original workbook?
Yes. Replace private values with neutral placeholders while keeping the same table shape, data types, and relationships. This protects sensitive information and still allows the query to be designed.
How do I show where the transposed data should be placed?
Create a second sheet named Expected Output and type the desired final layout. Highlight or label the target column and explain which source values should appear in it.
Does WPS Office support Power Query queries created in Microsoft Excel?
WPS Office Spreadsheet supports Power Query transformations and can open .xlsx files from Excel, so most query workflows can be reviewed. Complex external data sources may need to be refreshed after opening.




