Unpivot a Cross-Tabular Table - Ideas

[rod@rodmacpherson.com]

Hi folks,


I know how to invoke the syntax in MS SQL 2005 and beyond to execute an Unpivot syntax using t-sql


Does anyone know how to do this directly in MS Excel 2007 and beyond without having to invoke VBA ?

 

[NARAYANK991]

Hi Rod ,


I got the following link using Google ; see if it helps :


http://www.pcreview.co.uk/forums/perform-reverse-pivot-table-method-excel-2007-a-t3217682.html


The Walkenbach link gives the method.


There are more links here :


http://spreadsheet1.com/unpivot-data.html


and more information here :


http://superuser.com/questions/78439/is-it-possible-to-unpivot-or-reverse-pivot-in-excel


Narayan

 

[SirJB7]

Hi, rod@rodmacpherson.com!

May I suggest you to change your nick name? It's too long and it overlaps the comment area making it unreadable (Click on your name, Edit).

If you want to keep your email address you can put it in the website field of your profile, then when clicking on you nick on any comment the user will be led to your email.

Regards!