Cross referencing two User permission tables and presenting as a single table

Ianb1984

New Member
Joined
Feb 2, 2018
Messages
3
I'm analysing some system role based permissions, to understand and display which users have access to which permissions and perform a comparison.

The way the data has been presented to me so far is such that I have one table that presents permissions mapped into groups permission profiles (many to many) - Table 1 and another where I have all of the base user roles mapped to permission profiles - Table 2.

I’m trying To figure out the most efficient way now to display permissions mapped to roles as in (Table 3);

e.g of tables, this is where I am now

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Table 1
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 1
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 2
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 3
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 4
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 5
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 6
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 1
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 2
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 3
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 4
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 5
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 6
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 7
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 8
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]


<tbody>

</tbody>


[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]
 
[/FONT]
[/FONT]
[/FONT]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Table 2[/FONT][/FONT]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT][/FONT][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 1[/FONT][/FONT][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 2[/FONT][/FONT][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 3[/FONT][/FONT][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 4[/FONT][/FONT][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 5[/FONT][/FONT][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 6[/FONT][/FONT][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 7[/FONT][/FONT][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 8
[/FONT]
[/FONT]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 1[/FONT][/FONT][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x[/FONT][/FONT][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT]
[/FONT]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT]
[/FONT]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT][/FONT][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x[/FONT]
[/FONT]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT][/FONT]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT]
[/FONT]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x[/FONT][/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 2
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 3
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 4
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 5
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 6
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 7
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 8
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 9
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 10
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 11
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]


<tbody>

</tbody>


[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]This is where I want to be; so table 3 would look up the role, reference table 1 to obtain which permission profiles this role should have, then reference table 2 to obtain the individual permission items and mark them in table 3.
[/FONT]
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Table 3
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 1
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 2
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 3
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 4
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 5
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 6
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 1
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 2
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 3
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 4
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 5
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 6
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 7
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 8
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 9
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 10
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 11
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT]
[/FONT]

[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold] 
[/FONT]
[/FONT]


<tbody>
</tbody>
 

stunnrock

Board Regular
Joined
Dec 29, 2017
Messages
63
Hi. For the sake of this example, I'll assume that these tables are in A1:G9 and I1:Q12, with the results in S1:Y12


Put this into T2, entering it as a single-cell array formula (use Ctrl+Shift+Enter instead of just Enter):
Code:
=IF(SUMPRODUCT((INDEX($B$2:$G$9,,MATCH(T$1,$B$1:$G$1,0))="x")*TRANSPOSE((INDEX($J$2:$Q$12,MATCH($S2,$I$2:$I$12,0),)="x")))>0,"x","")
Copy T2 along U2:Y2, and then copy T2:Y2 downwards.
 

Ianb1984

New Member
Joined
Feb 2, 2018
Messages
3
Hey, wow thanks so far so good. I spent so long looking Up various combinations of look up and Index, Match but couldn't get it to work. This has worked for the above example. The real thing is much larger and spread across a few worksheets I'm going to see if I can apply it to the real thing!

I'll report back
 

Forum statistics

Threads
1,082,603
Messages
5,366,578
Members
400,904
Latest member
ndaines meriabi

Some videos you may like

This Week's Hot Topics

Top