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

I

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
[TABLE="width: 479"]

<tbody>[TR]
[TD="colspan: 7"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Table 1
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 19%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 1
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 2
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 3
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 4
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 5
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 6
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 19%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 1
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 19%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 2
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 19%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 3
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 19%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 4
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 19%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 5
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 19%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 6
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 19%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 7
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 19%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 8
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

</tbody>[/TABLE]


[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]
　
[/FONT][/FONT][/FONT]
[TABLE="width: 700"]

<tbody>[TR]
[TD="colspan: 9"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Table 2[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 14%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT][/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 1[/FONT][/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 2[/FONT][/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 3[/FONT][/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 4[/FONT][/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 5[/FONT][/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 6[/FONT][/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 7[/FONT][/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]PROFILE 8
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 14%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 1[/FONT][/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x[/FONT][/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT]
[/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT]
[/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT][/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x[/FONT]
[/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT][/FONT]
[/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold][/FONT]
[/FONT][/TD]

[TD="width: 11%"][FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 14%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 2
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 14%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 3
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 14%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 4
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 14%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 5
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 14%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 6
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 14%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 7
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 14%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 8
[/FONT]
[/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 14%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 9
[/FONT]
[/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 14%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 10
[/FONT]
[/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 14%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 11
[/FONT]
[/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 11%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[/TR]

</tbody>[/TABLE]


[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]
[TABLE="width: 479"]

<tbody>[TR]
[TD="colspan: 7"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Table 3
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 25%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 1
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 2
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 3
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 4
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 5
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]ROLE 6
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 25%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 1
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 25%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 2
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 25%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 3
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 25%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 4
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 25%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 5
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 25%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 6
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 25%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 7
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 25%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 8
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 25%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 9
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 25%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 10
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[/TR]

[TR]
[TD="width: 25%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]Permission 11
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]
[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]x
[/FONT][/FONT][/TD]

[TD="width: 13%"]
[FONT=Calibri,Arial Rounded MT Bold][FONT=Calibri,Arial Rounded MT Bold]　
[/FONT][/FONT][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Sort by date Sort by votes
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
You must log in or register to reply here.

Similar threads

S
  • Solved
Repeating rows
Replies
2
Views
158
sharshra
S
D
  • Solved
Filter on decremental list
Replies
5
Views
79
Peter_SSs
Peter_SSs
D
  • Question Question
Print Multiple invoices in one PDF File
Replies
1
Views
258
John_w
J
S
  • Solved
Few problems with dynamic arrays
2
Replies
15
Views
250
djclements
djclements
F
  • Solved
TEXTSPLIT not working as expected inside of BYROW. Workaround?
2
Replies
11
Views
553
felixstraube
F

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

Share this page

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