<img height="1" width="1" style="display:none;" alt="" src="https://dc.ads.linkedin.com/collect/?pid=214761&amp;fmt=gif">
Skip to the main content.
Why TimeXtender?

Every day we work to make the complex simple, to automate all that can be and to execute on what matters most.

Let us show you the Magic

Watch a Demo


See how others are building their data estates with TimeXtender, and learn how to follow in their footsteps.

  What's new?

New TimeXtender Community Platform

Join Now →

  Contact Us

We’d love to have a deeper discussion with you about your questions.

  Who We Are

Our core purpose is to empower the world with data, mind, and heart.

  Our Culture

We believe the “we are what we give” and that “people do business with people”.

  Join Us

We are a global, distributed workforce, organized in self-managed teams.

1 min read

Using Pivot & Unpivot

Featured Image

TimeXtender Tuesday - Episode 33

One of the sure things about data is that it is not always in the format needed for analysis. This episode of TimeXtender Tuesday focuses on using pivot and unpivot functions to quickly prepare data for analysis in the correct format.

The pivot and unpivot relational operators allow you to change table-valued expressions into another table, so it can be visualized in a way that fits your business needs. PIVOT turns unique values from one column into multiple columns, whereas UNPIVOT does the opposite and rotates columns in a table into values. Watch now to see an example of how it all works.

If you'd like to review previous TimeXtender Tuesdays sessions, check out our TimeXtender Tuesday playlist on YouTube.

TimeXtender Tuesday Links:

Taking it further:

7 min read

10 Ways TimeXtender's Partner Program Helps You Work Smarter

14 min read

The Top 10 AI Art Projects Of 2022

2 min read

We are data: Interviewing Rory Smith, Managing consultant at E-mergo