reverse pivot table-like data

[Bruce Meneghin]

I have data in a pivot table format (but not a pivot table) and want to
convert it to a normalized data structure

How I do dis?

Have this:

itemNum AttribA AttribB AttribC
001 X yy zz
002 A bb cc

want this:

itemNum Attribute Value
001 AttribA X
001 AttribB yy
001 AttirbC zz
002 AttribA A
002 AttribB bb
002 AttirbC cc

 

[Debra Dalgleish]

To reorganize the data, you can try the "unpivot' technique described by
John Walkenbach:

http://j-walk.com/ss/excel/usertips/tip068.htm