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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to 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
213
sharshra
S
I
  • Solved
Excel Filtering for a Summary Tab
2 3 4
Replies
35
Views
665
ItalianPlatinum
I
R
  • Solved
TEXTSPLIT into Rows but Maintain Grouping
Replies
5
Views
112
Cubist
Cubist
D
  • Solved
Filter on decremental list
Replies
5
Views
121
Peter_SSs
Peter_SSs
D
  • Question Question
Print Multiple invoices in one PDF File
Replies
1
Views
353
John_w
J

Forum statistics

Threads
1,224,823
Messages
6,181,171
Members
453,021
Latest member
Justyna P

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