Unpivot a table
A table with one column per month reads well, but cannot be filtered or pivoted. Unpivoting turns it into a list, one row per product and month; pivoting goes the other way.
What this tool does
- The columns to keep as they are, your choice; the others become rows.
- The names of the two new columns, your choice ("Month", "Amount").
- Empty cells skipped or kept.
- Pivot: the values of one column become columns, with duplicates flagged.
What it does not do: When pivoting, the same key with the same attribute keeps only its first value; the number of values ignored is shown.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Open a large file : Over a million rows, several gigabytes: browse, filter, sort, export.
- Automatic pivot table : Useful pivots suggested, dates grouped, the table and its chart.
- SQL queries : SELECT, JOIN, GROUP BY on your files, with no database.
- Convert a spreadsheet : XLSX, CSV, ODS, JSON, in every direction, sheet by sheet.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.