Unpivot (Wide → Long)
Turn column headers like Jan, Feb, Mar into rows – the “tidy data” shape charts and pivots need.
| product | Month | sales |
|---|---|---|
| Apples | Jan | 10 |
| Apples | Feb | 12 |
| Apples | Mar | 9 |
| Pears | Jan | 4 |
| Pears | Mar | 7 |
Runs entirely in your browser. Nothing is sent anywhere.
How it works
- 1Paste or type your text.
- 2Choose the options you need.
- 3Copy or download the result.
About this tool
Unpivot (Wide → Long): Turn column headers like Jan, Feb, Mar into rows – the “tidy data” shape charts and pivots need. Paste your text and the result appears immediately, ready to copy or download. Everything happens locally in your browser — nothing you paste is uploaded or stored.
Example
Input
product,Jan,Feb,Mar Apples,10,12,9 Pears,4,,7
Output
product,month,sales Apples,Jan,10 Apples,Feb,12 Apples,Mar,9 Pears,Jan,4 Pears,Mar,7
How do I use the Unpivot (Wide → Long)?
Paste or type your text. Choose the options you need. Copy or download the result.
Is the Unpivot (Wide → Long) free?
Yes. It is completely free with no sign-up, no usage limits and no watermark.
Is my data sent to a server?
No. Everything is calculated locally in your browser. Nothing you enter is uploaded, logged or stored.
Does it work on my phone?
Yes. It works in any modern browser on Android, iPhone, iPad, Windows, Mac and Linux — no app needed.