D
Darryl
I inherited a data structure that has a primary table with a one-to-many
relationship to a second table. Each entry in the primary table has 27
entries in the secondary table for each entry in the primary table -- an
identifier (C1, C2, etc), and a value (10, 20, 30, 40, and so on).
I need to convert this "vertical" configuration and make it horizontal. By
virtue of the data structure the report looks like:
Record No.1 Primary table row 1
C1 10
C2 20
C3 40
Record No.2 Primary table row 2
C1 10
C2 20
C3 40
Would like it to be:
Record C1 C2 C3
1 10 20 30
2 15 20 40
Has anyone faced this before? How did you solve it?
relationship to a second table. Each entry in the primary table has 27
entries in the secondary table for each entry in the primary table -- an
identifier (C1, C2, etc), and a value (10, 20, 30, 40, and so on).
I need to convert this "vertical" configuration and make it horizontal. By
virtue of the data structure the report looks like:
Record No.1 Primary table row 1
C1 10
C2 20
C3 40
Record No.2 Primary table row 2
C1 10
C2 20
C3 40
Would like it to be:
Record C1 C2 C3
1 10 20 30
2 15 20 40
Has anyone faced this before? How did you solve it?