Logo

Unpivoting (Melting)

Upload a dataset to begin

Supported formats: .csv,.xlsx,.xls,.xlsm,.xlsb,.tsv

Not signed in: Up to 20kB per day, no sign-up needed.
Sign in for free for unlimited files, no payment required.

About Unpivoting (Melting)

Transform wide data (months as columns) into long format.

Also known as "Melting" or "Reverse Pivot". This tool is essential for preparing Excel reports for Tableau, PowerBI, or Database ingestion.

It takes columns that represent values (e.g., "Jan", "Feb", "Mar") and turns them into rows, creating a "clean" dataset.

Category: Transformation & Logic

Common Use Cases

  • Preparing monthly sales sheets for database import
  • Cleaning survey data for visualization
  • Restructuring financial reports

Key Features

  • Select multiple "value" columns to unpivot at once (e.g. all 12 month columns)
  • Keeps chosen identifier columns fixed while melting the rest into rows
  • Auto-generates "variable" and "value" columns from the melted headers

The Unpivoting (Melting) tool is compatible with: PowerBI, Tableau, SQL Databases.

If you accidentally need the wide layout back for a human-readable report, Pivot reverses this exact transformation; once the long format is ready, export it with CSV to XLSX for BI tools that expect an Excel input.

Frequently Asked Questions

What's "wide" vs "long" format?

Wide format spreads values across separate columns (like Jan, Feb, Mar), long format puts them in rows instead, which is what most databases and BI tools expect.

Why would Tableau or Power BI need long format?

Those tools generally expect one row per observation rather than one column per time period or category, so unpivoting is a common prep step before importing.

A standard prep step for BI developers loading spreadsheet exports into Tableau, Power BI, or a SQL table.

Read the related guide →