reverse pivot table-like data
 

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

reverse pivot table-like data
 

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

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

Bruce Meneghin wrote:
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
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com