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>
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,264
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top