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

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
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
194
sharshra
S
D
  • Solved
Filter on decremental list
Replies
5
Views
94
Peter_SSs
Peter_SSs
D
  • Question Question
Print Multiple invoices in one PDF File
Replies
1
Views
305
John_w
J
S
  • Solved
Few problems with dynamic arrays
2
Replies
15
Views
294
djclements
djclements
A
  • Solved
Could not set the RowSource property. Invalid property value. Error 380
2
Replies
16
Views
210
RoryA
RoryA

Forum statistics

Threads
1,223,889
Messages
6,175,223
Members
452,620
Latest member
dsubash

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