Power Query turns wide reports into refresh-ready tables
Reviewed by Helen Jones
A new practical Power Query walkthrough shows how to turn a worksheet with one column per month into a tidy table with one Amount column and one row per account-month. It also covers the traps that appear with real date headers, totals rows and recorded type-change steps that name the current month columns.
Wide spreadsheets look like finished reports, but they make the next question harder: a new month, changed view or PivotTable can require another manual reshape. A tidy table separates the source from the report, so the same data can support different account, department, monthly and quarterly views. The useful check is in the refresh path, not the first transformation. If Power Query has recorded a step that explicitly names Jan through Jun, a later July column can be missed or break the query. Report owners should test a deliberately added future period before trusting the monthly refresh.
Analysis
Pick one recurring workbook that has a column per month. Make a copy, unpivot its period columns, then add a test future-month column and refresh; inspect Applied Steps for hard-coded column names before you hand the output to a PivotTable or Power BI.
Source note
Pulse published by Collab365 Spaces, reviewed by Helen Jones on . Cite as "Power Query turns wide reports into refresh-ready tables", Collab365 Spaces.