Dear,
I almost gave up but this forum may save me!
I have a file with basically four variables; Study name, IV (Independent variable), DV (Dependent variable), and IV_DV (Combination of IV and DV).
I can make two-way pivot tables of Study name by IV, Study name by DV, and Study name by IV_DV, or three-way table of Study name by IV by DV, and so on.
But my report (table) should arrange as:
For each study,
List of IV
List of DV
List of IV_DV.
As you know, if I make a three-way PV table, it works like Do Loop (i, j, k). What I want is , for the given i, all j, then all k.
I have attached the image of the example file. (Is there no way to attach my file here?) Thank you very much for your attention.
I almost gave up but this forum may save me!
I have a file with basically four variables; Study name, IV (Independent variable), DV (Dependent variable), and IV_DV (Combination of IV and DV).
I can make two-way pivot tables of Study name by IV, Study name by DV, and Study name by IV_DV, or three-way table of Study name by IV by DV, and so on.
But my report (table) should arrange as:
For each study,
List of IV
List of DV
List of IV_DV.
As you know, if I make a three-way PV table, it works like Do Loop (i, j, k). What I want is , for the given i, all j, then all k.
I have attached the image of the example file. (Is there no way to attach my file here?) Thank you very much for your attention.