| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reverse Pivot-type Data (that's not a pivot table) | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| Database table (aka Reverse pivot table) | Excel Discussion (Misc queries) | |||
| reverse a pivot table | Excel Discussion (Misc queries) | |||
| Change data to appear in rows instead of columns (reverse a table. | Excel Discussion (Misc queries) | |||
Linear Mode
