Jul
8

Transform your crosstab to list with Unpivot Table for Excel

If you've been searching the web for an easy and flexible way to unpivot data in Excel, you are in the right place at the right time. Ablebits have just released a new tool for Ultimate Suite. This little add-in will easily convert your crosstab table to a normalized list.
Unpivot Table for Excel will normalize your data table

If you often create summary reports with Excel Pivot Table functionality, sometimes you may need to turn your crosstab table to list. The point is that many analysis and visualization tools, like Tableau, or Protovis, don't work with pivoted data. Here you start searching for a VBA macro or any other possibility to transform your summary table to list. Good news is that you can simply use Unpivot Table add-in and get the necessary results in seconds.

Unpivot your Excel table in seconds

The Unpivot Table tool is a part of Ultimate Suite by Ablebits. Thus to try it out, please download and install the latest version of Ultimate Suite to your PC.

When you open Excel, you will see the Unpivot Table icon under the Ablebits Data tab in the Transform section.
See the Unpivot Table icon under the Ablebits Data tab

Just open your Pivot Table by clicking on its icon, choose if you want to separate the resulting parts by an empty row and select the destination for your list. It's possible to place the results to a new workbook or worksheet.
See how Unpivot Table settings look like

That's it! Forget the time when you needed to spend hours manipulating and transforming your spreadsheets. Unpivot Table for Excel will normalize your crosstab list and will prepare it for further processing with complex visualization

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Excel add-ins and Outlook tools - Ablebits.com
Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard