Convert Power BI Text Data into a Structured Excel Report in WPS Spreadsheets
Question details
The user needs to transform a raw text file containing SRS, PRACH, PUSCH, and PUCCH channel records into a structured Excel report with Sample_Power headers.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A raw text file contains repeated telecommunications channel records that must be organized into a tabular Excel report.
- Observed behavior
- The data is currently unstructured and cannot be directly used as a report, so the goal is to split each record into fields, identify the channel name, and pivot the data under the required Sample_Power headers.
Before you start, open the raw text file in a text editor and confirm the delimiter or fixed-width positions used between fields, and locate the repeated records for SRS, PRACH, PUSCH, and PUCCH.
Import the text file with Power Query and pivot channel fields into Sample_Power headers
Use this method when the raw text file is consistent and you need a repeatable, structured import without manually copying rows.
Power Query in WPS Spreadsheets can connect to a text file, split records into columns, and reshape rows into headers. This is the best choice when the same channel names appear many times and must become Sample_Power columns.
In WPS Spreadsheets, open a new workbook and go to the Data tab, then choose Import Data > From Text/CSV.
Select the raw text file, set the delimiter or fixed width according to your file, and click Load or Transform Data to open the Power Query editor.
In the Power Query editor, select the record column, go to Transform > Split Column, choose By Delimiter or By Number of Characters, and name the resulting fields for later identification.
Use Add Column > Conditional Column or Extract to create a helper column that returns SRS, PRACH, PUSCH, or PUCCH based on the record content, so each row has a channel type.
Select the channel name column, go to Transform > Pivot Column, choose the field or value column to aggregate, then click Close & Load to send the structured report to the worksheet.
Split the text with Text to Columns and rebuild the report with formulas
Use this fallback when the data is small or you only need a one-time transformation without Power Query.
Build a Structured Excel Report from Text in WPS Spreadsheets
Use WPS Spreadsheets to import raw text, split channel records into fields, and pivot SRS, PRACH, PUSCH, and PUCCH data into a structured Sample_Power report. The final workbook remains fully compatible with Microsoft Excel and Power BI.
- 1. Select the text import tool: In WPS Spreadsheets, go to Data > Import Data > From Text/CSV and choose the raw text file.
- 2. Split and identify fields: In the Power Query editor, split the record column by delimiter or position, then add a helper column for SRS, PRACH, PUSCH, or PUCCH.
- 3. Pivot channel names into headers: Select the channel helper column, go to Transform > Pivot Column, and choose the value field to create Sample_Power headers.
- 4. Load the structured report: Click Close & Load to open the structured table in a worksheet, then save it as .xlsx for Excel or Power BI.
Frequently Asked Questions
Can WPS Spreadsheets handle a raw text file with channel records?
Yes. Open a workbook, go to Data > Import Data > From Text/CSV, select the file, and choose the delimiter or fixed width that matches the raw records.
How do I split a single text record into multiple columns?
In the Power Query editor, select the column and use Transform > Split Column. Choose By Delimiter or By Number of Characters, then rename the output fields.
How do I turn SRS, PRACH, PUSCH, and PUCCH rows into Sample_Power headers?
Create a helper column that identifies the channel name, then select that column and use Transform > Pivot Column with the value field you want under each header.
What if my text file does not use a single consistent delimiter?
Check the file preview first. If needed, split by fixed widths or clean the data in a text editor before importing, then use conditional columns to identify the channel type.
Will the final report open in Microsoft Excel and Power BI?
Yes. Save the transformed worksheet as .xlsx; it remains compatible with Microsoft Excel and can be used as a data source in Power BI.
