I use report and have the table as shown below.
The original column name are Parent and Child
Row 1: Parent A and Child B
Row 2: Parent B and Child C
Row 3: Parent D and Child E
Row 4: Parent E and Child F
Row 5: arent Z and Child V
I want to reorganize the report to be like that:
Column: Parent, Child, Child1, Child 2
Row 1: Parent A, Child B and child1 C
Row 2: Parent D, Child E child1 F and child2 G
Row 3: Parent Z, Child V
What the query or select expert i should use it?