Pivottable display multiple matching rows

[cactus12]

I have two tables with the following headers/data, where the first table has one result per ID and the second table has multiple results per ID, e.g.:

NAME, DATA1, DATA2, DATA3, ID
Joe Smith, M, New York, 10101, 9898
Mary Jones, F, New York, 10110, 2424

NAME, ID, DATA4, DATA5, DATA6
Joe Smith, 9898, 1/1/20, active, B
Joe Smith, 9898, 2/1/20, active, B
Joe Smith, 9898, 3/1/20, active, B
Joe Smith, 9898, 4/1/20, not active, (null)
Joe Smith, 9898, 5/1/20, not active, (null)
Mary Jones, 2424, 1/1/20, not active, (null)
Mary Jones, 2424, 2/1/20, active, C
Mary Jones, 2424, 3/1/20, active, C
Mary Jones, 2424, 4/1/20, active, A
Mary Jones, 2424, 5/1/20, active, A


I have a relationship set up on ID, and the pivottable will show summed vaues correctly, but I cannot get it to display something like:

Joe Smith
M
New York
10101
9898
1/1/20
active
B
2/1/20
active
B
3/1/20
active
B
4/1/20
not active
5/1/20
not active
Mary Jones
F
New York
10110
2424
1/1/20
not active
2/1/20
active
C
3/1/20
active
C
4/1/20
active
A
5/1/20
active
A

Is this possible? Thanks in advance.

 

[cactus12]

 

[cactus12]

Here is a better representation of the data display I am looking for:

Joe Smith 
    M
        New York
            10101
                9898
                    1/1/20
                        active
                            B
                    2/1/20
                        active
                            B
                    3/1/20
                        active
                            B
                    4/1/20
                        not active
                    5/1/20
                        not active
Mary Jones 
    F
        New York
            10110
                2424
                    1/1/20
                        not active
                    2/1/20
                        active
                            C
                    3/1/20
                        active
                            C
                    4/1/20
                        active
                            A
                    5/1/20
                        active
                            A