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.

prettytable

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:

  • 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.

 

Thomas

About these ads

10 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.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s