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 averaged sensor data, 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

Show advanced transforms

Unpivot Excel data

Unpivot Excel data table

Unpivot Excel data table

Unpivot Excel

Unpivot Excel

For more information on Gather options see the Gather documentation.

As well as unpivoting data, Easy Data Transform also allows you to combine 56 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. If you need to unpivot lots of Excel sheets you can do it in a single operation using the batch processing feature.

Try it free now!

Windows Logo Windows Download

v1.21.0 for Windows 10 / 8 / 7 (37 MB)

Apple Logo Mac Download

v1.21.0 for Mac 11.x to 10.13 (38 MB)


Questions or problems?

Email support@easydatatransform.com