How to Combine Two Notes Columns in WPS Spreadsheets and Improve Data Layout
Question details
The user needs to merge two separate notes columns into one comments field in a WPS spreadsheet and improve the worksheet layout for easier monthly reporting.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A workbook tracks monthly dialogue and balances, but duplicate customer and balance columns make reporting difficult.
- Observed behavior
- Notes 1 and Notes 2 are stored in separate columns, and the worksheet contains duplicate customer and balance columns.
Open the WPS Spreadsheets workbook and identify the columns that contain Notes 1, Notes 2, and the target comments field. If you plan to restructure the layout, review which customer and balance columns are duplicated and which transaction details must remain unique.
Combine the Notes Columns with a TEXTJOIN Formula
Use this quick formula method when you only need to merge Notes 1 and Notes 2 into a single comments field without rearranging the entire worksheet.
Click the first empty cell in your Comments column, such as H2, in WPS Spreadsheets.
Type =TEXTJOIN(" ",TRUE,B2,G2) and press Enter to combine Notes 1 and Notes 2 while ignoring empty cells.
Drag the fill handle from the lower-right corner of H2 down through all data rows, or double-click the fill handle to auto-fill the formula.
Restructure the Worksheet into a Single-Row Transaction Layout
Use this approach when you need cleaner monthly reporting and easier maintenance, because each row represents one transaction instead of using duplicate customer and balance columns.
Merge Notes and Clean Up Your Spreadsheet Layout in WPS Spreadsheets
Use TEXTJOIN and a single-row transaction layout in WPS Spreadsheets to combine Notes 1 and Notes 2 into one comments field, avoid spacing issues, and simplify monthly reporting.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office, open the Excel-compatible workbook, and click the worksheet that contains the two notes columns.
- 2. Enter the TEXTJOIN formula: In the first empty cell of your Comments column, type =TEXTJOIN(" ",TRUE,B2,G2) and press Enter to combine the two note cells without extra spaces.
- 3. Fill the formula down: Drag the fill handle from the bottom-right corner of the formula cell down through all data rows, or double-click the fill handle to auto-fill the formula.
- 4. Restructure duplicate columns: Create headers such as Date, Account Number, Name, Transaction Type, Debit, Credit, Balance, and Notes, then move each transaction to its own row and remove duplicate customer or balance columns.
Frequently Asked Questions
Can I combine two notes columns in WPS Spreadsheets when one cell is empty?
Yes. Use =TEXTJOIN(" ",TRUE,B2,G2). The TRUE argument tells WPS Spreadsheets to ignore empty cells, so the combined note will not contain an extra leading, trailing, or double space.
Which formula merges Notes 1 and Notes 2 without adding an unwanted space?
TEXTJOIN is the best choice. =B2&" "&G2 works but always adds a space, while =TEXTJOIN(" ",TRUE,B2,G2) only adds a delimiter between non-empty values.
How do I apply the merge formula to all rows in the worksheet?
Enter the formula in the first row, then drag the fill handle from the lower-right corner of the cell down through all data rows. You can also double-click the fill handle to auto-fill adjacent populated rows.
What layout is easier for monthly balance reporting?
A single-row transaction layout is easier: Date, Account Number, Name, Transaction Type, Debit, Credit, Balance, and Notes. This avoids duplicate customer and balance columns and makes summarizing by month much simpler.
Will WPS Spreadsheets keep my Excel formulas and .xlsx formatting?
Yes. WPS Spreadsheets opens, edits, and saves .xlsx workbooks while preserving formulas, cell formatting, and worksheet structure for Microsoft Excel compatibility.
