The unpivot add-in

Too many times in Excel, you need to analyze and exploit data that someone gave you. Most of the times, that involves a pretty table with nice formatting that you can’t use for anything except it’s original purpose. Something like this, that could you easily reproduce in a pivot if you had the data formatted the right way to start with, rather than the other way around.


If like me, you’d rather get better analysis than formatting, and can’t really live without a pivot table, what you really want is this: a clean data table ready to be used in a pivot, i.e. one column per data type, no duplicates columns, no blanks, etc. Something like this:

table2db step 2

You can do it in a couple easy steps once you’ve installed my unpivot add-in, Table 2 DB. Download it here: Table 2 DB:

  • Select the first cell of your detail data and run the add-in from your add-ins ribbon.
  • Validate the parameters on the first screen

table2db 1

  • Validate the parameters on the second screen:

table2db 2

  • Do a final cleanup on the data: adjust formatting for dates, add titles, etc.

table2db step 1

  • I’m ready for my pivot, Mr. DeMille.


Try it, you might like it.




27 comments on “The unpivot add-in

  1. Jennifer says:

    You are fantastic.

  2. khaled says:

    thank you

  3. Joel says:

    Ouahh, Thomas! So many usefull things on your page!! Thanks!

  4. lelan says:

    Great site! Thanks!

  5. Ryan says:

    You Rock! Thanks!

  6. Tom Enns says:

    Yup! This was awesome!

  7. Jomili says:

    Okay, I’m the dumb one; I’ve installed the add-in, but it’s not in my add-ins ribbon. How do I run it?

  8. Mattia says:

    Thanks a lot… it’s very helpful for production planner as well:-)

  9. Andrew says:

    This is an awesome add-in, thank you so much!

  10. Dave says:

    This was a great help to me– thanks.

  11. […] I have built an add-in that will let you do that, and that makes it easy to adapt to different situations. Check it out here: […]

  12. Sam says:

    This is fantastic! I have used it to create a TB from a QuickBooks P&L by class report, which has enabled me to automate production of month end accounts. Really super – thank so much!

  13. Stephanie says:

    You are AWESOME! Thank you!

  14. Dorin says:

    awesome! thanks

  15. A.User says:

    Excellent. Thanks a lot for making this available

  16. Giuseppe says:

    I would believe it’s fantastic: it is exactly wht I am looking for.
    But how may I get this add-in?

  17. Marc Stickfort says:

    Just downloaded it and tried it – looks terrific. Thanks a lot!

  18. Jaslyn C says:

    Hello, I don’t see the download. Where do I find it?

  19. Sagar says:

    Thank u. The tool is amazing.

  20. Kal says:

    Thank you so much for this. This is a LIFESAVER!!!!!!

  21. Pieter says:

    This is a real time saver, thanks!

  22. rach says:

    Thank you, This worked Super!

  23. AdF says:

    Seriously you are awesome for writing that!

  24. Michiel says:

    Great stuff! Thx a lot!

  25. Gerardo leon says:

    You will go to heaven!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s