How to Stack 13 Monthly Excel Columns into One Month and Amount Column in Excel 2013
Question details
The user needs to convert 13 monthly amount columns into a normalized table with repeated identifying columns, a Month column, and an Amount column without manually copying and pasting.

- Product
- Microsoft Excel 2013 with Power Query
- Device & OS
- not provided
- Scenario
- The user has a wide-format source table with 13 monthly amount columns and wants to reshape it for reporting, pivot tables, or further analysis.
- Observed behavior
- The source data is in wide format, and the user wants a long-format Month and Amount table instead of manually copying and pasting values.
Check whether the Power Query add-in is enabled in Excel 2013. If month headings are stored as text, convert them to real dates before unpivoting so the Month field sorts chronologically.
Unpivot Monthly Columns with Power Query in Excel 2013
Use this method when Power Query is installed or can be enabled in Excel 2013; it creates a clean Month and Amount table without manual copying.
Power Query is the safest way to normalize a wide monthly table. It keeps a live query linked to the source range, so the unpivoted result can be refreshed when new month columns are added or values change.
In Excel 2013, click the Power Query tab, select a cell inside the source table, and choose 'From Table' to open the Query Editor.
In the Query Editor, hold Ctrl and click the headers of the columns that should repeat on each row, such as Customer, Account, or Region.
Go to Transform > Unpivot Other Columns. Power Query changes the 13 monthly amount columns into two columns named Attribute and Value.
Right-click the Attribute column, choose Rename, and type Month. Right-click the Value column, choose Rename, and type Amount.
Click Home > Close & Load to return the normalized table to a new worksheet.

Manual Unpivot Without Power Query
Use this structured manual method when the Power Query add-in cannot be installed or enabled in Excel 2013.
Use WPS Spreadsheets as a Free Excel Alternative for Spreadsheet Cleanup
The Power Query unpivot feature belongs to Microsoft Excel 2013, and WPS Office does not include that specific Microsoft add-in. For everyday spreadsheet work, WPS Spreadsheets is a free, lightweight, familiar alternative that opens and edits Excel workbooks with high format compatibility, so you can still review, format, filter, and summarize data without buying Microsoft Office.
- 1. Download and install WPS Office: Go to the WPS Office download page and install WPS Office Free on your Windows or Mac computer.
- 2. Open the Excel workbook: Launch WPS Spreadsheets and open the .xlsx workbook that contains the 13 monthly columns.
- 3. Use WPS data tools for cleanup and summaries: Use the Data tab in WPS Spreadsheets to sort, filter, or create pivot table summaries; for Power Query-specific unpivoting, keep Excel 2013 available for that step.

Frequently Asked Questions
Can I unpivot columns in Excel 2013 without installing Power Query?
Yes. You can use a manual formula method with INDEX, INT, and MOD to repeat identifying values, months, and amounts. It works without the add-in but is more error-prone and needs maintenance if the source layout changes.
Why should month headings be converted to real dates before unpivoting?
If the month headings remain as text, the resulting Month column may sort alphabetically. Real dates allow chronological sorting, date grouping, and easier time-based reports after the unpivot.
Does WPS Spreadsheets include Power Query?
WPS Spreadsheets does not include the Microsoft Power Query add-in. For the specific unpivot operation described here, use Excel 2013 with Power Query or use a manual formula method in WPS or Excel.
Can the unpivoted table update when the source data changes?
Yes, if you use the Power Query method. The loaded table remains linked to the source query, so you can right-click it and choose Refresh to pull in updated source values.




