F
FUBARinSFO
Hi:
Sorry I don't have a good handle or name to call what I want to do
here. It goes one step beyond "unpivot" of a pivot table. I want to
expand or strew the summarized rows back into individual row detail.
Below is a model of what I'm trying to accomplish.
I already know how to move from Table 1 to Table 2 (Joel Horowitz or
John Walkenbach, thank you). Thank you in advance for any help you can
give regarding moving from Table 2 to Table 3.
-- Roy Zider
Table 1 -- pivot table
labels 2001 2002
rec1 1 4
rec2 2 5
rec3 3 6
Table 2 -- "Unpivot" table data
Rows Columns Data
rec1 2001 1
rec2 2001 2
rec3 2001 3
rec1 2002 4
rec2 2002 5
rec3 2002 6
Table 3 - expansion to individual records/rows,where the number of
rows is the number in the Data column. Just want to duplicate records
at the moment. Other data to follow, not germane to this problem.
Rows Columns Data
rec1 2001 1
rec2 2001 2
rec2 2001 2
rec3 2001 3
rec3 2001 3
rec3 2001 3
rec1 2002 4
rec1 2002 4
rec1 2002 4
rec1 2002 4
rec1 2002 4
rec2 2002 5
rec2 2002 5
rec2 2002 5
rec2 2002 5
rec2 2002 5
rec3 2002 6
rec3 2002 6
rec3 2002 6
rec3 2002 6
rec3 2002 6
rec3 2002 6
rec3 2002 6
Sorry I don't have a good handle or name to call what I want to do
here. It goes one step beyond "unpivot" of a pivot table. I want to
expand or strew the summarized rows back into individual row detail.
Below is a model of what I'm trying to accomplish.
I already know how to move from Table 1 to Table 2 (Joel Horowitz or
John Walkenbach, thank you). Thank you in advance for any help you can
give regarding moving from Table 2 to Table 3.
-- Roy Zider
Table 1 -- pivot table
labels 2001 2002
rec1 1 4
rec2 2 5
rec3 3 6
Table 2 -- "Unpivot" table data
Rows Columns Data
rec1 2001 1
rec2 2001 2
rec3 2001 3
rec1 2002 4
rec2 2002 5
rec3 2002 6
Table 3 - expansion to individual records/rows,where the number of
rows is the number in the Data column. Just want to duplicate records
at the moment. Other data to follow, not germane to this problem.
Rows Columns Data
rec1 2001 1
rec2 2001 2
rec2 2001 2
rec3 2001 3
rec3 2001 3
rec3 2001 3
rec1 2002 4
rec1 2002 4
rec1 2002 4
rec1 2002 4
rec1 2002 4
rec2 2002 5
rec2 2002 5
rec2 2002 5
rec2 2002 5
rec2 2002 5
rec3 2002 6
rec3 2002 6
rec3 2002 6
rec3 2002 6
rec3 2002 6
rec3 2002 6
rec3 2002 6