How to unpivot Excel

You can ‘unpivot’ a table of Excel data in a few clicks using Easy Data Transform. For example, you might want to unpivot this table of daily hourly averaged sensor data. It is arranged by hour (column) and day (row):

Unpivot Excel example

Into a form where there is a separate row for each hour and day:

Unpivot Excel example

Unpivot Excel data

Unpivot Excel data

Unpivot Excel data table

Unpivot Excel data table

Unpivot Excel

Unpivot Excel

As well as unpivoting data, Easy Data Transform also allows you to combine 52 transforms in many other ways to quickly and easily create complex data transformations for numerical, text and date data. For example you could add some additional transforms to produced timestamped data:

Unpivot Excel columns

Unpivot Excel timestamped

And re-pivot to average the data by day:

Unpivot Excel columns

Excel pivot average

You can File>Open the unpivot.transform file included in unpivot.zip to try the above.

Easy Data Transform can process millions of rows and input and output in multiple formats. See our quick start guide to find out more about working with Easy Data Transform.

Try it free now!

Windows Logo Windows Download

v1.18.0 for Windows 10 / 8 / 7 (36 MB)

Apple Logo Mac Download

v1.18.0 for Mac 11.x to 10.13 (36 MB)


Questions or problems?

Email support@easydatatransform.com


Do you have a question?
We would love to help.

This pop-up will not be shown again